APPS.PQP_NL_ABP_FUNCTIONS dependencies on PAY_ELEMENT_TYPES_F

Line 274: ,pay_element_types_f pet

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'
278: AND pet.legislation_code = 'NL'

Line 317: l_element_type_id PAY_ELEMENT_TYPES_F.element_type_id%TYPE;

313: AND paa.assignment_id = p_assignment_id
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:

Line 4819: pay_element_types_f pet

4815: --
4816: CURSOR c_abp_schm IS
4817: SELECT fnd_number.canonical_to_number(eei_information2) pty_id
4818: FROM pay_element_type_extra_info pete,
4819: pay_element_types_f pet
4820: WHERE pete.information_type = 'PQP_NL_ABP_DEDUCTION'
4821: AND pete.element_type_id = pet.element_type_id
4822: AND p_date_earned BETWEEN pet.effective_start_date
4823: AND pet.effective_end_date

Line 6051: ,pay_element_types_f pet

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'
6055: AND p_date_earned BETWEEN piv.effective_start_date

Line 6408: ,p_element_type_id IN pay_element_types_f.element_type_id%TYPE

6404: (p_date_earned IN DATE
6405: ,p_business_group_id IN pqp_pension_types_f.business_group_id%TYPE
6406: ,p_assignment_id IN per_all_assignments_f.assignment_id%TYPE
6407: ,p_assignment_action_id IN per_all_assignments_f.assignment_id%TYPE
6408: ,p_element_type_id IN pay_element_types_f.element_type_id%TYPE
6409: ,p_start_date IN DATE
6410: ,p_end_date IN DATE
6411: )
6412:

Line 7308: ,p_retr_ele_type_id pay_element_types_f.element_type_id%TYPE)

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
7312: WHERE element_type_id = p_retr_ele_type_id