DBA Data[Home] [Help]

APPS.PQP_US_FF_FUNCTIONS dependencies on PER_ALL_ASSIGNMENTS_F

Line 288: per_all_assignments_f PAA

284: --+
285: CURSOR c_assignment IS
286: SELECT 'x'
287: FROM per_people_extra_info PEI,
288: per_all_assignments_f PAA
289: WHERE PEI.information_type = 'PER_US_ADDITIONAL_DETAILS'
290: AND PEI.pei_information12 = 'WINDSTAR'
291: AND PEI.person_id = PAA.person_id
292: AND PAA.assignment_id = p_assignment_id;

Line 428: FROM per_all_assignments_f pas

424: AND pei.pei_information5 = p_income_code
425: AND pei.information_type = 'PER_US_PAYROLL_DETAILS'
426: AND person_id IN
427: (SELECT pas.person_id
428: FROM per_all_assignments_f pas
429: WHERE pas.assignment_id = p_assignment_id
430: AND l_effective_date BETWEEN pas.effective_start_date
431: AND pas.effective_end_date);
432: --+