APPS.PQP_NL_PENSION_EXTRACTS dependencies on PAY_INPUT_VALUES_F

Line 717: FROM pay_input_values_f

713: -- Cursor to get the input value id for the pension basis input value
714: -- ============================================================================
715: CURSOR c_get_iv_id(c_element_type_id in number) IS
716: SELECT input_value_id
717: FROM pay_input_values_f
718: WHERE element_type_id = c_element_type_id
719: AND name = 'ABP Employee Pension Basis';
720:
721: l_basis_iv_id NUMBER;

Line 742: pay_input_values_f pivf,

738: pay_element_types_f pet,
739: pay_element_entries_f peef,
740: pay_element_links_f pelf,
741: pay_element_entry_values_f peev,
742: pay_input_values_f pivf,
743: pqp_pension_types_f pty
744: WHERE pei.information_type = 'PQP_NL_ABP_DEDUCTION'
745: AND pei.eei_information_category = 'PQP_NL_ABP_DEDUCTION'
746: AND c_effective_date BETWEEN To_Date(pei.eei_information10,'DD/MM/RRRR') AND

Line 827: pay_input_values_f pivf,

823: pay_element_types_f pet,
824: pay_element_entries_f peef,
825: pay_element_links_f pelf,
826: pay_element_entry_values_f peev,
827: pay_input_values_f pivf,
828: pqp_pension_types_f pty
829: WHERE pei.information_type = 'PQP_NL_ABP_DEDUCTION'
830: AND pei.eei_information_category = 'PQP_NL_ABP_DEDUCTION'
831: AND c_effective_date BETWEEN To_Date(pei.eei_information10,'DD/MM/RRRR') AND

Line 938: FROM pay_input_values_f piv

934: CURSOR c_get_retro_ele(c_element_name in varchar2
935: ,c_input_value_name in varchar2) IS
936: SELECT piv.input_value_id
937: ,pet.element_type_id
938: FROM pay_input_values_f piv
939: ,pay_element_types_f pet
940: WHERE piv.name = c_input_value_name
941: AND piv.element_type_id = pet.element_type_id
942: AND pet.element_name = c_element_name;