APPS.PAY_MX_SOC_SEC_ARCHIVE dependencies on PAY_INPUT_VALUES_F

Line 1203: ,pay_input_values_f piv

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
1207: AND ppe.change_type = 'DATE_EARNED'

Line 1352: ,pay_input_values_f piv

1348: ,paa.abs_information_category
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

Line 1400: FROM pay_input_values_f piv

1396: ,pee.assignment_id
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

Line 1682: FROM pay_input_values_f piv

1678: ,pee.assignment_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

Line 1727: p_iv_name pay_input_values_f.name%type,

1723: INFONAVIT transactions 18, 19 and 20. */
1724: PROCEDURE load_infonavit_trans (
1725: p_element_entry_id NUMBER,
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

Line 1745: FROM pay_input_values_f piv

1741: ,pee.assignment_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

Line 3849: ,pay_input_values_f piv

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
3853: AND cp_effective_date BETWEEN piv.effective_start_date