APPS.PAY_NL_ABP_ARCHIVE dependencies on PAY_INPUT_VALUES_F

Line 204: pay_input_values_f pivf,

200: pay_element_types_f pet,
201: pay_element_entries_f peef,
202: pay_element_links_f pelf,
203: pay_element_entry_values_f peev,
204: pay_input_values_f pivf,
205: pqp_pension_types_f pty
206: WHERE pei.information_type = 'PQP_NL_ABP_DEDUCTION'
207: AND pei.eei_information_category = 'PQP_NL_ABP_DEDUCTION'
208: AND c_effective_date BETWEEN to_date(pei.eei_information10,'DD/MM/RRRR') AND

Line 1148: FROM pay_input_values_f piv

1144: ,c_effective_date IN DATE) IS
1145: SELECT piv.input_value_id start_dt_id
1146: ,piv1.input_value_id end_dt_id
1147: ,pet.element_type_id
1148: FROM pay_input_values_f piv
1149: ,pay_input_values_f piv1
1150: ,pay_element_types_f pet
1151: WHERE piv.name = 'Start Date'
1152: AND piv.element_type_id = pet.element_type_id

Line 1149: ,pay_input_values_f piv1

1145: SELECT piv.input_value_id start_dt_id
1146: ,piv1.input_value_id end_dt_id
1147: ,pet.element_type_id
1148: FROM pay_input_values_f piv
1149: ,pay_input_values_f piv1
1150: ,pay_element_types_f pet
1151: WHERE piv.name = 'Start Date'
1152: AND piv.element_type_id = pet.element_type_id
1153: AND piv1.name = 'End Date'

Line 1237: FROM pay_input_values_f piv

1233: CURSOR csr_get_retro_ele(c_element_name IN VARCHAR2
1234: ,c_input_value_name IN VARCHAR2) IS
1235: SELECT piv.input_value_id
1236: ,pet.element_type_id
1237: FROM pay_input_values_f piv
1238: ,pay_element_types_f pet
1239: WHERE piv.name = c_input_value_name
1240: AND piv.element_type_id = pet.element_type_id
1241: AND pet.element_name = c_element_name;

Line 1504: FROM pay_input_values_f

1500: -- Cursor to get the input value id for the pension basis input value
1501: -- ============================================================================
1502: CURSOR csr_get_iv_id(c_element_type_id in number) IS
1503: SELECT input_value_id
1504: FROM pay_input_values_f
1505: WHERE element_type_id = c_element_type_id
1506: AND name = 'ABP Employee Pension Basis';
1507:
1508: -- ============================================================================