DBA Data[Home] [Help]

APPS.PSP_ENC_CREATE_LINES dependencies on PER_PEOPLE_F

Line 415: per_assignments_f paf,per_people_f ppf

411: CURSOR assign_num_cur IS
412: SELECT paf.assignment_number,
413: ppf.employee_number
414: FROM
415: per_assignments_f paf,per_people_f ppf
416: WHERE paf.assignment_id =p_assignment_id
417: AND paf.person_id =ppf.person_id
418: AND p_effective_date between paf.effective_start_date and paf.effective_end_date
419: AND p_effective_date between ppf.effective_start_date and ppf.effective_end_date;