DBA Data[Home] [Help]

APPS.PAY_FR_DADS_EMP_PKG dependencies on PAY_ELEMENT_TYPES_F

Line 1031: , pay_element_types_f pet

1027: Cursor fetch_pension_info(p_date Date) Is
1028: Select pef.entry_information1 pension_info--Used in employment cat code
1029: From pay_element_entries_f pef
1030: , pay_element_links_f pel
1031: , pay_element_types_f pet
1032: , per_all_assignments_f asg
1033: , hr_organization_information org_est
1034: ,pay_assignment_actions paa
1035: Where paa.assignment_action_id = g_assign_action_id

Line 1108: ,pay_element_types_f pet

1104: Cursor get_multi_emp(p_effective_date DATE) Is
1105: Select pef.element_entry_id element_entry_id
1106: From pay_element_entries_f pef
1107: ,pay_element_links_f pel
1108: ,pay_element_types_f pet
1109: Where pef.assignment_id = p_assignment_id
1110: And pef.element_link_id = pel.element_link_id
1111: And pel.element_type_id = pet.Element_type_id
1112: And pet.element_name = 'FR_MULTIPLE_EMPLOYER'