APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on PAY_ELEMENT_TYPES_F

Line 1129: ,pay_element_types_f pet

1125: ,pay_event_updates peu
1126: ,pay_dated_tables pdt
1127: ,pay_element_entry_values_f peev
1128: ,pay_input_values_f piv
1129: ,pay_element_types_f pet
1130: WHERE ppe.business_group_id = p_business_group_id
1131: AND ppe.assignment_id = p_assignment_id
1132: AND ppe.change_type = 'DATE_EARNED'
1133: AND ppe.creation_date BETWEEN p_start_date

Line 1157: ,pay_element_types_f pet

1153: FROM pay_process_events ppe
1154: ,pay_event_updates peu
1155: ,pay_dated_tables pdt
1156: ,pay_element_entries_f pee
1157: ,pay_element_types_f pet
1158: WHERE ppe.business_group_id = p_business_group_id
1159: AND ppe.assignment_id = p_assignment_id
1160: AND ppe.change_type = 'DATE_EARNED'
1161: AND ppe.creation_date BETWEEN p_start_date

Line 1226: FROM pay_element_types_f pet

1222: AND ((eei_information1 = 'MX_BASE' AND gv_IDW_calc_method = 'B')
1223: OR (eei_information1 = 'MX_IDWF' AND gv_IDW_calc_method <> 'B'))
1224: UNION ALL
1225: SELECT 'MX_IDWV'
1226: FROM pay_element_types_f pet
1227: ,pay_element_classifications pec
1228: ,pay_sub_classification_rules_f psr
1229: WHERE pet.element_type_id = cp_element_type_id
1230: AND cp_effective_date BETWEEN pet.effective_start_date

Line 1534: lv_creator_type pay_element_types_f.creator_type%type;

1530: PROCEDURE parse_all_ele_entries (p_effective_date DATE) IS
1531: ln_element_entry_id NUMBER;
1532: ln_element_type_id NUMBER;
1533: lv_idw_type VARCHAR2(40);
1534: lv_creator_type pay_element_types_f.creator_type%type;
1535: BEGIN
1536: OPEN c_all_ele_entries (p_effective_date);
1537: LOOP
1538: FETCH c_all_ele_entries INTO ln_element_entry_id;