APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 1204: ,pay_element_types_f pet

1200: ,pay_event_updates peu
1201: ,pay_dated_tables pdt
1202: ,pay_element_entry_values_f peev
1203: ,pay_input_values_f piv
1204: ,pay_element_types_f pet
1205: WHERE ppe.business_group_id = p_business_group_id
1206: AND ppe.assignment_id = p_assignment_id
1207: AND ppe.change_type = 'DATE_EARNED'
1208: AND ppe.creation_date BETWEEN p_start_date

Line 1232: ,pay_element_types_f pet

1228: FROM pay_process_events ppe
1229: ,pay_event_updates peu
1230: ,pay_dated_tables pdt
1231: ,pay_element_entries_f pee
1232: ,pay_element_types_f pet
1233: WHERE ppe.business_group_id = p_business_group_id
1234: AND ppe.assignment_id = p_assignment_id
1235: AND ppe.change_type = 'DATE_EARNED'
1236: AND ppe.creation_date BETWEEN p_start_date

Line 1301: FROM pay_element_types_f pet

1297: AND ((eei_information1 = 'MX_BASE' AND gv_IDW_calc_method = 'B')
1298: OR (eei_information1 = 'MX_IDWF' AND gv_IDW_calc_method <> 'B'))
1299: UNION ALL
1300: SELECT 'MX_IDWV'
1301: FROM pay_element_types_f pet
1302: ,pay_element_classifications pec
1303: ,pay_sub_classification_rules_f psr
1304: WHERE pet.element_type_id = cp_element_type_id
1305: AND cp_effective_date BETWEEN pet.effective_start_date

Line 1619: lv_creator_type pay_element_types_f.creator_type%type;

1615: PROCEDURE parse_all_ele_entries (p_effective_date DATE) IS
1616: ln_element_entry_id NUMBER;
1617: ln_element_type_id NUMBER;
1618: lv_idw_type VARCHAR2(40);
1619: lv_creator_type pay_element_types_f.creator_type%type;
1620: BEGIN
1621: OPEN c_all_ele_entries (p_effective_date);
1622: LOOP
1623: FETCH c_all_ele_entries INTO ln_element_entry_id;