[Home] [Help]
1227: SELECT ppe.effective_date
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
1237: AND p_end_date
1238: AND peu.event_update_id = ppe.event_update_id
1239: AND pdt.dated_table_id = peu.dated_table_id
1240: AND pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
1241: AND ppe.surrogate_key = pee.element_entry_id
1242: AND pee.element_type_id = pet.element_type_id
1243: AND pet.element_name = 'Integrated Daily Wage'
1244: AND pet.legislation_code = 'MX'
1248: AND pet.effective_end_date;
1249:
1250: CURSOR c_all_ele_entries (cp_effective_date IN DATE) IS
1251: SELECT element_entry_id
1252: FROM pay_element_entries_f
1253: WHERE assignment_id = p_assignment_id
1254: AND cp_effective_date BETWEEN effective_start_date
1255: AND effective_end_date;
1256:
1272: AND ppe.creation_date BETWEEN cp_start_date
1273: AND cp_end_date
1274: AND peu.event_update_id = ppe.event_update_id
1275: AND pdt.dated_table_id = peu.dated_table_id
1276: AND pdt.table_name = 'PAY_ELEMENT_ENTRIES_F'
1277: ORDER BY ppe.effective_date;
1278:
1279: CURSOR c_ele_type_id ( cp_element_entry_id IN NUMBER
1280: , cp_effective_date IN DATE ) IS
1281: SELECT element_type_id
1282: ,creator_type
1283: ,effective_start_date
1284: ,effective_end_date
1285: FROM pay_element_entries_f
1286: WHERE element_entry_id = cp_element_entry_id
1287: AND cp_effective_date BETWEEN effective_start_date
1288: AND effective_end_date;
1289:
1349: --,paa.abs_information1 disability_type
1350: ,paa.abs_information2 disability_id
1351: FROM per_absence_attendance_types paat
1352: ,pay_input_values_f piv
1353: ,pay_element_entries_f pee
1354: --,pay_element_entry_values_f peev (Bug 5355325)
1355: ,per_absence_attendances paa
1356: WHERE paat.business_group_id = cp_business_group_id
1357: AND NVL(paat.information1, 'N')= 'Y'
1397: ,peev.screen_entry_value
1398: ,pee.effective_start_date
1399: ,pee.effective_end_date
1400: FROM pay_input_values_f piv
1401: ,pay_element_entries_f pee
1402: ,pay_element_entry_values_f peev
1403: WHERE piv.effective_start_date <= cp_end_date
1404: AND piv.effective_end_date >= cp_start_date
1405: AND piv.element_type_id = cp_element_type_id
1419: CURSOR csr_infonavit_tran_16 (cp_element_type_id NUMBER,
1420: cp_start_date DATE,
1421: cp_end_date DATE) IS
1422: SELECT element_entry_id
1423: FROM pay_element_entries_f
1424: WHERE assignment_id = p_assignment_id
1425: AND element_type_id = cp_element_type_id
1426: AND effective_start_date BETWEEN cp_start_date AND cp_end_date;
1427:
1533: AND ppe.assignment_id = p_assignment_id
1534: AND ppe.change_type = 'DATE_EARNED'
1535: AND peu.event_update_id = ppe.event_update_id
1536: AND pdt.dated_table_id = peu.dated_table_id
1537: AND ((pdt.table_name = 'PAY_ELEMENT_ENTRIES_F')
1538: OR (pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'))
1539: AND peu.event_type = 'INSERT';
1540: BEGIN
1541: IF event_qualified (p_person_id,
1679: ,peev.screen_entry_value
1680: ,pee.effective_start_date
1681: ,pee.effective_end_date
1682: FROM pay_input_values_f piv
1683: ,pay_element_entries_f pee
1684: ,pay_element_entry_values_f peev
1685: WHERE piv.effective_start_date <= p_end_date
1686: AND piv.effective_end_date >= p_start_date
1687: AND piv.element_type_id = p_element_type_id
1742: ,peev.screen_entry_value
1743: ,pee.effective_start_date
1744: ,pee.effective_end_date
1745: FROM pay_input_values_f piv
1746: ,pay_element_entries_f pee
1747: ,pay_element_entry_values_f peev
1748: WHERE piv.effective_start_date <= cp_end_date
1749: AND piv.effective_end_date >= cp_start_date
1750: AND piv.element_type_id = cp_element_type_id
3650:
3651: per_count := per_count + 1;
3652: per_events(per_count) := int_pkg_events(i);
3653:
3654: ELSIF lv_table_name = 'PAY_ELEMENT_ENTRIES_F' THEN
3655:
3656: ele_count := ele_count + 1;
3657: ele_events(ele_count) := int_pkg_events(i);
3658:
3823: CURSOR c_ee_for_infonavit( cp_person_id NUMBER
3824: ,cp_effective_date DATE ) IS
3825: SELECT pee.element_entry_id
3826: ,pee.element_type_id
3827: FROM pay_element_entries_f pee
3828: ,per_all_assignments_f paf
3829: WHERE paf.person_id = cp_person_id
3830: AND cp_effective_date BETWEEN paf.effective_start_date
3831: AND paf.effective_end_date
4233: AND rownum = 1;
4234:
4235: CURSOR c_chk_elements IS
4236: select 'Y'
4237: from pay_element_entries_f pee
4238: ,pay_sub_classification_rules_f psc
4239: ,pay_element_classifications pec
4240: ,pay_assignment_actions paa
4241: ,pay_payroll_actions ppa2
4539: ,paf.assignment_id
4540: ,'Y' variable_idw
4541: FROM per_assignments_f paf
4542: ,pay_payroll_actions ppa
4543: ,pay_element_entries_f pee
4544: ,pay_sub_classification_rules_f psc
4545: ,pay_element_classifications pec
4546: ,pay_assignment_actions paa
4547: ,pay_payroll_actions ppa2
4624: ,'Y' variable_idw
4625: FROM pay_payroll_actions ppa
4626: ,per_assignments_f paf
4627: ,pay_population_ranges ppr
4628: ,pay_element_entries_f pee
4629: ,pay_sub_classification_rules_f psc
4630: ,pay_element_classifications pec
4631: ,pay_assignment_actions paa
4632: ,pay_payroll_actions ppa2