Scribd
Upload
10 views1 page

6 Assignment Query

Uploaded by

ishaqalikhan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
10 views1 page

6 Assignment Query

Uploaded by

ishaqalikhan
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as TXT, PDF, TXT or read online on Scribd
You are on page 1/ 1

select organization_id from per_all_assignments_f asg_act

where asg_act.person_id(+) = 100000005177874


AND UPPER (asg_act.assignment_type(+)) IN ('E', 'P','C') --TO GET ALL
RECORDS THOUGH ASSIGNMENT TYPE DETAILS NOT INCLUDED FOR ALL
AND UPPER (asg_act.primary_flag) =
CASE asg_act.assignment_type
WHEN 'E' THEN 'Y'
WHEN 'P' THEN 'N'
WHEN 'C' THEN 'Y'
ELSE NULL
END
AND TRUNC (SYSDATE) BETWEEN TRUNC (
NVL (asg_act.effective_start_date(+), --TO
GET ALL RECORDS THOUGH ASSIGNMENT EFFECTIVE DETAILS NOT INCLUDED FOR ALL
SYSDATE))
AND TRUNC (
NVL (asg_act.effective_end_date(+),
SYSDATE))
AND UPPER (TRIM (asg_act.effective_latest_change)) = 'Y'
AND UPPER (TRIM (asg_act.assignment_status_type)) = 'ACTIVE'

You might also like