[Home] [Help]
139: consider INFONAVIT transactions
140: occuring in future with respect to
141: archiver's end date.
142: sdahiya 28-Jun-2006 115.33 5355325 Removed undesired join with
143: pay_element_entry_values_f in
144: cursor c_abs_info.
145: vpandya 25-Aug-2006 115.34 Initializing gn_implementation to
146: zero when there is no payroll
147: action before the current one so
1123: SELECT ppe.effective_date
1124: FROM pay_process_events ppe
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
1133: AND ppe.creation_date BETWEEN p_start_date
1134: AND p_end_date
1135: AND peu.event_update_id = ppe.event_update_id
1136: AND pdt.dated_table_id = peu.dated_table_id
1137: AND pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
1138: AND ppe.surrogate_key = peev.element_entry_value_id
1139: AND peev.input_value_id = piv.input_value_id
1140: AND piv.element_type_id = pet.element_type_id
1141: AND pet.element_name = 'Integrated Daily Wage'
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'
1283: /*
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
1331: AND pee.element_entry_id = cp_element_entry_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,
1457: p_assignment_id,
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
1603: AND pee.element_entry_id = p_element_entry_id
1641: p_element_type_id NUMBER,
1642: p_iv_name pay_input_values_f.name%type,
1643: p_effective_start_date DATE,
1644: p_effective_end_date DATE,
1645: p_screen_entry_value pay_element_entry_values_f.screen_entry_value%type,
1646: p_tran_type VARCHAR2) IS
1647:
1648: CURSOR c_infonavit_info ( cp_assignment_id NUMBER
1649: ,cp_element_entry_id NUMBER
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
1666: AND pee.element_entry_id = cp_element_entry_id
3450:
3451: ele_count := ele_count + 1;
3452: ele_events(ele_count) := int_pkg_events(i);
3453:
3454: ELSIF lv_table_name = 'PAY_ELEMENT_ENTRY_VALUES_F' THEN
3455:
3456: eev_count := eev_count + 1;
3457: eev_events(eev_count) := int_pkg_events(i);
3458:
3631: CURSOR c_infonavit( cp_element_type_id NUMBER
3632: ,cp_element_entry_id NUMBER
3633: ,cp_effective_date DATE ) IS
3634: SELECT piv.name, peev.screen_entry_value
3635: FROM pay_element_entry_values_f peev
3636: ,pay_input_values_f piv
3637: WHERE piv.element_type_id = cp_element_type_id
3638: AND peev.element_entry_id = cp_element_entry_id
3639: AND piv.input_value_id = peev.input_value_id