[Home] [Help]
1152: SELECT ppe.effective_date
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
1162: AND p_end_date
1163: AND peu.event_update_id = ppe.event_update_id
1164: AND pdt.dated_table_id = peu.dated_table_id
1165: AND pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
1166: AND ppe.surrogate_key = pee.element_entry_id
1167: AND pee.element_type_id = pet.element_type_id
1168: AND pet.element_name = 'Integrated Daily Wage'
1169: AND pet.legislation_code = 'MX'
1173: AND pet.effective_end_date;
1174:
1175: CURSOR c_all_ele_entries (cp_effective_date IN DATE) IS
1176: SELECT element_entry_id
1177: FROM pay_element_entries_f
1178: WHERE assignment_id = p_assignment_id
1179: AND cp_effective_date BETWEEN effective_start_date
1180: AND effective_end_date;
1181:
1197: AND ppe.creation_date BETWEEN cp_start_date
1198: AND cp_end_date
1199: AND peu.event_update_id = ppe.event_update_id
1200: AND pdt.dated_table_id = peu.dated_table_id
1201: AND pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
1202: ORDER BY ppe.effective_date;
1203:
1204: CURSOR c_ele_type_id ( cp_element_entry_id IN NUMBER
1205: , cp_effective_date IN DATE ) IS
1206: SELECT element_type_id
1207: ,creator_type
1208: ,effective_start_date
1209: ,effective_end_date
1210: FROM pay_element_entries_f
1211: WHERE element_entry_id = cp_element_entry_id
1212: AND cp_effective_date BETWEEN effective_start_date
1213: AND effective_end_date;
1214:
1274: --,paa.abs_information1 disability_type
1275: ,paa.abs_information2 disability_id
1276: FROM per_absence_attendance_types paat
1277: ,pay_input_values_f piv
1278: ,pay_element_entries_f pee
1279: --,pay_element_entry_values_f peev (Bug 5355325)
1280: ,per_absence_attendances paa
1281: WHERE paat.business_group_id = cp_business_group_id
1282: AND NVL(paat.information1, 'N')= 'Y'
1322: ,peev.screen_entry_value
1323: ,pee.effective_start_date
1324: ,pee.effective_end_date
1325: FROM pay_input_values_f piv
1326: ,pay_element_entries_f pee
1327: ,pay_element_entry_values_f peev
1328: WHERE piv.effective_start_date <= cp_end_date
1329: AND piv.effective_end_date >= cp_start_date
1330: AND piv.element_type_id = cp_element_type_id
1344: CURSOR csr_infonavit_tran_16 (cp_element_type_id NUMBER,
1345: cp_start_date DATE,
1346: cp_end_date DATE) IS
1347: SELECT element_entry_id
1348: FROM pay_element_entries_f
1349: WHERE assignment_id = p_assignment_id
1350: AND element_type_id = cp_element_type_id
1351: AND effective_start_date BETWEEN cp_start_date AND cp_end_date;
1352:
1448: AND ppe.assignment_id = p_assignment_id
1449: AND ppe.change_type = 'DATE_EARNED'
1450: AND peu.event_update_id = ppe.event_update_id
1451: AND pdt.dated_table_id = peu.dated_table_id
1452: AND ((pdt.table_name = 'PAY_ELEMENT_ENTRIES_F')
1453: OR (pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'))
1454: AND peu.event_type = 'INSERT';
1455: BEGIN
1456: IF event_qualified (p_person_id,
1594: ,peev.screen_entry_value
1595: ,pee.effective_start_date
1596: ,pee.effective_end_date
1597: FROM pay_input_values_f piv
1598: ,pay_element_entries_f pee
1599: ,pay_element_entry_values_f peev
1600: WHERE piv.effective_start_date <= p_end_date
1601: AND piv.effective_end_date >= p_start_date
1602: AND piv.element_type_id = p_element_type_id
1657: ,peev.screen_entry_value
1658: ,pee.effective_start_date
1659: ,pee.effective_end_date
1660: FROM pay_input_values_f piv
1661: ,pay_element_entries_f pee
1662: ,pay_element_entry_values_f peev
1663: WHERE piv.effective_start_date <= cp_end_date
1664: AND piv.effective_end_date >= cp_start_date
1665: AND piv.element_type_id = cp_element_type_id
3445:
3446: per_count := per_count + 1;
3447: per_events(per_count) := int_pkg_events(i);
3448:
3449: ELSIF lv_table_name = 'PAY_ELEMENT_ENTRIES_F' THEN
3450:
3451: ele_count := ele_count + 1;
3452: ele_events(ele_count) := int_pkg_events(i);
3453:
3610: CURSOR c_ee_for_infonavit( cp_person_id NUMBER
3611: ,cp_effective_date DATE ) IS
3612: SELECT pee.element_entry_id
3613: ,pee.element_type_id
3614: FROM pay_element_entries_f pee
3615: ,per_all_assignments_f paf
3616: WHERE paf.person_id = cp_person_id
3617: AND cp_effective_date BETWEEN paf.effective_start_date
3618: AND paf.effective_end_date
4100: ') UNION ALL '||
4101: 'SELECT paf.person_id
4102: FROM per_assignments_f paf
4103: ,pay_payroll_actions ppa
4104: ,pay_element_entries_f pee
4105: ,pay_sub_classification_rules_f psc
4106: ,pay_element_classifications pec
4107: ,pay_assignment_actions paa
4108: ,pay_payroll_actions ppa2
4208: ,paf.assignment_id
4209: ,'Y' variable_idw
4210: FROM per_assignments_f paf
4211: ,pay_payroll_actions ppa
4212: ,pay_element_entries_f pee
4213: ,pay_sub_classification_rules_f psc
4214: ,pay_element_classifications pec
4215: ,pay_assignment_actions paa
4216: ,pay_payroll_actions ppa2
4293: ,'Y' variable_idw
4294: FROM pay_payroll_actions ppa
4295: ,per_assignments_f paf
4296: ,pay_population_ranges ppr
4297: ,pay_element_entries_f pee
4298: ,pay_sub_classification_rules_f psc
4299: ,pay_element_classifications pec
4300: ,pay_assignment_actions paa
4301: ,pay_payroll_actions ppa2