DBA Data[Home] [Help]

APPS.PAY_US_ELEMENT_ENTRY_HOOK dependencies on PER_ALL_ASSIGNMENTS_F

Line 723: ,per_all_assignments_f paa

719: ,c_end_date date) is
720: select 1
721: from per_jobs perj
722: ,per_jobs_tl perjtl
723: ,per_all_assignments_f paa
724: where paa.assignment_id = c_assignment_id
725: and c_start_date <= paa.effective_end_date
726: and c_end_date >= paa.effective_start_date
727: and nvl(perj.job_information3, 'EX') = 'NEX'