APPS.PQP_NL_ABP_FUNCTIONS dependencies on PAY_INPUT_VALUES_F

Line 273: FROM pay_input_values_f piv

269: --
270: CURSOR c_inp_val IS
271: SELECT piv.input_value_id
272: ,pet.element_type_id
273: FROM pay_input_values_f piv
274: ,pay_element_types_f pet
275: WHERE piv.element_type_id = pet.element_type_id
276: AND pet.element_name = 'ABP Pensions Part Time Percentage'
277: AND piv.name = 'Part Time Percentage'

Line 318: l_input_value_id PAY_INPUT_VALUES_F.input_value_id%TYPE;

314: AND paa.action_status = 'C' )
315: AND rownum = 1;
316:
317: l_element_type_id PAY_ELEMENT_TYPES_F.element_type_id%TYPE;
318: l_input_value_id PAY_INPUT_VALUES_F.input_value_id%TYPE;
319: l_element_entry_id PAY_ELEMENT_ENTRIES_F.element_entry_id%TYPE;
320: l_ass_act NUMBER;
321:
322: BEGIN

Line 6050: FROM pay_input_values_f piv

6046: --for the Reduction Percentage input
6047: CURSOR c_get_abs_ele IS
6048: SELECT piv.input_value_id
6049: ,pet.element_type_id
6050: FROM pay_input_values_f piv
6051: ,pay_element_types_f pet
6052: WHERE piv.name = 'Reduction Percentage'
6053: AND piv.element_type_id = pet.element_type_id
6054: AND pet.element_name = 'ABP Pensions Premium Reduction Information'

Line 7290: FROM pay_input_values_f piv,

7286: --
7287: CURSOR csr_iv_pv_id(p_time_span_id IN number)
7288: IS
7289: SELECT piv.element_type_id ele_id, piv.input_value_id iv_id
7290: FROM pay_input_values_f piv,
7291: pay_retro_component_usages prcu,
7292: pay_retro_components prc,
7293: pay_element_span_usages pesu
7294: WHERE prc.legislation_code = 'NL'

Line 7307: CURSOR csr_iv_id(p_iv_name IN pay_input_values_f.name%TYPE

7303:
7304: --
7305: -- Cursor to fetch input value id based on retro_element_type_id
7306: --
7307: CURSOR csr_iv_id(p_iv_name IN pay_input_values_f.name%TYPE
7308: ,p_retr_ele_type_id pay_element_types_f.element_type_id%TYPE)
7309: IS
7310: SELECT input_value_id
7311: FROM pay_input_values_f

Line 7311: FROM pay_input_values_f

7307: CURSOR csr_iv_id(p_iv_name IN pay_input_values_f.name%TYPE
7308: ,p_retr_ele_type_id pay_element_types_f.element_type_id%TYPE)
7309: IS
7310: SELECT input_value_id
7311: FROM pay_input_values_f
7312: WHERE element_type_id = p_retr_ele_type_id
7313: AND name = p_iv_name
7314: AND p_date_earned BETWEEN effective_start_date AND effective_end_date;
7315: --