DBA Data[Home] [Help]

APPS.PSP_PREGEN dependencies on PER_ALL_ASSIGNMENTS_F

Line 2515: per_all_assignments_f paf,

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