DBA Data[Home] [Help]

APPS.PSP_PREGEN dependencies on PAY_ELEMENT_TYPES_F

Line 1365: FROM pay_element_types_f pef

1361: -- Introduced this for bug fix 2916848
1362: AND c.start_date <= a.end_date_active
1363: AND c.end_date >= a.start_date_active
1364: AND EXISTS (SELECT 1
1365: FROM pay_element_types_f pef
1366: WHERE pef.element_type_id = a.element_type_id
1367: AND ( pef.output_currency_code = g_currency_code
1368: OR g_currency_code = 'STAT')
1369: AND pef.effective_end_date >= a.start_date_active

Line 2516: pay_element_types_f pet,

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
2520: and paf.assignment_id = l_assignment_id