APPS.PQP_NL_PENSION_EXTRACTS dependencies on PAY_INPUT_VALUES_F

Line 736: FROM pay_input_values_f

732: -- Cursor to get the input value id for the pension basis input value
733: -- ============================================================================
734: CURSOR c_get_iv_id(c_element_type_id in number) IS
735: SELECT input_value_id
736: FROM pay_input_values_f
737: WHERE element_type_id = c_element_type_id
738: AND name = 'ABP Employee Pension Basis';
739:
740: l_basis_iv_id NUMBER;

Line 761: pay_input_values_f pivf,

757: pay_element_types_f pet,
758: pay_element_entries_f peef,
759: pay_element_links_f pelf,
760: pay_element_entry_values_f peev,
761: pay_input_values_f pivf,
762: pqp_pension_types_f pty
763: WHERE pei.information_type = 'PQP_NL_ABP_DEDUCTION'
764: AND pei.eei_information_category = 'PQP_NL_ABP_DEDUCTION'
765: AND c_effective_date BETWEEN To_Date(pei.eei_information10,'DD/MM/RRRR') AND

Line 846: pay_input_values_f pivf,

842: pay_element_types_f pet,
843: pay_element_entries_f peef,
844: pay_element_links_f pelf,
845: pay_element_entry_values_f peev,
846: pay_input_values_f pivf,
847: pqp_pension_types_f pty
848: WHERE pei.information_type = 'PQP_NL_ABP_DEDUCTION'
849: AND pei.eei_information_category = 'PQP_NL_ABP_DEDUCTION'
850: AND c_effective_date BETWEEN To_Date(pei.eei_information10,'DD/MM/RRRR') AND

Line 957: FROM pay_input_values_f piv

953: CURSOR c_get_retro_ele(c_element_name in varchar2
954: ,c_input_value_name in varchar2) IS
955: SELECT piv.input_value_id
956: ,pet.element_type_id
957: FROM pay_input_values_f piv
958: ,pay_element_types_f pet
959: WHERE piv.name = c_input_value_name
960: AND piv.element_type_id = pet.element_type_id
961: AND pet.element_name = c_element_name;

Line 3557: FROM pay_input_values_f piv

3553:
3554: CURSOR c_ude_ele_iv_id(p_bg_id NUMBER, p_effective_date DATE) IS
3555: SELECT piv.input_value_id start_dt_id, piv1.input_value_id end_dt_id
3556: ,pet.element_type_id
3557: FROM pay_input_values_f piv
3558: ,pay_input_values_f piv1
3559: ,pay_element_types_f pet
3560: WHERE piv.name = 'Start Date'
3561: AND piv.element_type_id = pet.element_type_id

Line 3558: ,pay_input_values_f piv1

3554: CURSOR c_ude_ele_iv_id(p_bg_id NUMBER, p_effective_date DATE) IS
3555: SELECT piv.input_value_id start_dt_id, piv1.input_value_id end_dt_id
3556: ,pet.element_type_id
3557: FROM pay_input_values_f piv
3558: ,pay_input_values_f piv1
3559: ,pay_element_types_f pet
3560: WHERE piv.name = 'Start Date'
3561: AND piv.element_type_id = pet.element_type_id
3562: AND piv1.name = 'End Date'