DBA Data[Home] [Help]

APPS.PAY_US_ELEMENT_ENTRY_HOOK dependencies on PER_JOBS

Line 721: from per_jobs perj

717: cursor c_check_flsa_elig_job(c_assignment_id number
718: ,c_start_date date
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

Line 722: ,per_jobs_tl perjtl

718: ,c_start_date date
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