[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
1198: SELECT ppe.effective_date
1199: FROM pay_process_events ppe
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
1208: AND ppe.creation_date BETWEEN p_start_date
1209: AND p_end_date
1210: AND peu.event_update_id = ppe.event_update_id
1211: AND pdt.dated_table_id = peu.dated_table_id
1212: AND pdt.table_name = 'PAY_ELEMENT_ENTRY_VALUES_F'
1213: AND ppe.surrogate_key = peev.element_entry_value_id
1214: AND peev.input_value_id = piv.input_value_id
1215: AND piv.element_type_id = pet.element_type_id
1216: AND pet.element_name = 'Integrated Daily Wage'
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'
1358: /*
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
1406: AND pee.element_entry_id = cp_element_entry_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,
1542: p_assignment_id,
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
1688: AND pee.element_entry_id = p_element_entry_id
1726: p_element_type_id NUMBER,
1727: p_iv_name pay_input_values_f.name%type,
1728: p_effective_start_date DATE,
1729: p_effective_end_date DATE,
1730: p_screen_entry_value pay_element_entry_values_f.screen_entry_value%type,
1731: p_tran_type VARCHAR2) IS
1732:
1733: CURSOR c_infonavit_info ( cp_assignment_id NUMBER
1734: ,cp_element_entry_id NUMBER
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
1751: AND pee.element_entry_id = cp_element_entry_id
3655:
3656: ele_count := ele_count + 1;
3657: ele_events(ele_count) := int_pkg_events(i);
3658:
3659: ELSIF lv_table_name = 'PAY_ELEMENT_ENTRY_VALUES_F' THEN
3660:
3661: eev_count := eev_count + 1;
3662: eev_events(eev_count) := int_pkg_events(i);
3663:
3844: CURSOR c_infonavit( cp_element_type_id NUMBER
3845: ,cp_element_entry_id NUMBER
3846: ,cp_effective_date DATE ) IS
3847: SELECT piv.name, peev.screen_entry_value
3848: FROM pay_element_entry_values_f peev
3849: ,pay_input_values_f piv
3850: WHERE piv.element_type_id = cp_element_type_id
3851: AND peev.element_entry_id = cp_element_entry_id
3852: AND piv.input_value_id = peev.input_value_id