DBA Data[Home] [Help]

APPS.PSP_PREGEN dependencies on PER_ALL_ASSIGNMENTS_F

Line 2518: per_all_assignments_f paf,

2514: paf.assignment_number,
2515: pet.element_name,
2516: hou.name
2517: from per_all_people_f ppf,
2518: per_all_assignments_f paf,
2519: pay_element_types_f pet,
2520: hr_all_organization_units hou
2521: where ppf.person_id = p_person_id
2522: and p_effective_date between paf.effective_start_date and paf.effective_end_date