DBA Data[Home] [Help]

APPS.PAY_US_ELEMENT_ENTRY_HOOK dependencies on PER_ALL_ASSIGNMENTS_F

Line 751: ,per_all_assignments_f paa

747: ,c_end_date date) is
748: select 1
749: from per_jobs perj
750: ,per_jobs_tl perjtl
751: ,per_all_assignments_f paa
752: where paa.assignment_id = c_assignment_id
753: and c_start_date <= paa.effective_end_date
754: and c_end_date >= paa.effective_start_date
755: and nvl(perj.job_information3, 'EX') = 'NEX'