DBA Data[Home] [Help]

APPS.PSP_PREGEN dependencies on PAY_ELEMENT_TYPES_F

Line 1368: FROM pay_element_types_f pef

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

Line 2519: pay_element_types_f pet,

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