Human Capital Management - EBS (MOSC)

MOSC Banner

Sql Query Need

edited Oct 2, 2012 7:54PM in Human Capital Management - EBS (MOSC) 6 commentsAnswered
Hi All,
Pls help me to prepare sql query as per below requirement:
I have created below records through application.

                                  Effective_Start_date                   Effective_end_date
Contingent Worker   01-Jan-2012                                   09-Jan-2012

Employee                 10-Jan-2012                                 31-Dec-4712

User will pass two parameters like start_date and end_date. Sql code work in such a way that,

Start_date : 01-Jan-2012
end_date : 08-jan-2012       Sql code return one record(Contingent worker)


start_date: 11-Jan-2012
End_date : 30-Jan-2012  return one record like Employee

Start_date:01-Jan-2012
End_date:30-Jan-2012  Display two records (Contingent worker and EMployee).

Need query accordingly.



Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

EBS HCM Tags

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center