APPS.PAY_GB_RTI_P60 dependencies on PAY_ELEMENT_TYPES_F

Line 3668: FROM pay_element_types_f petf,

3664: CURSOR csr_ni_details
3665: IS
3666: SELECT petf.element_type_id,
3667: input_value_id
3668: FROM pay_element_types_f petf,
3669: pay_input_values_f pivf
3670: WHERE petf.element_name = 'NI'
3671: AND petf.element_type_id = pivf.element_type_id
3672: AND pivf.name = 'Process Type'

Line 3751: FROM pay_element_types_f

3747: hr_utility.trace('l_first_fps_run_date: '||l_first_fps_run_date);
3748:
3749: SELECT distinct element_type_id
3750: INTO g_paye_element_id
3751: FROM pay_element_types_f
3752: WHERE element_name = 'PAYE'
3753: AND legislation_code = 'GB';
3754:
3755: SELECT distinct element_type_id

Line 3757: FROM pay_element_types_f

3753: AND legislation_code = 'GB';
3754:
3755: SELECT distinct element_type_id
3756: INTO g_paye_details_id
3757: FROM pay_element_types_f
3758: WHERE element_name = 'PAYE Details'
3759: AND legislation_code = 'GB';
3760:
3761: hr_utility.trace('g_paye_element_id: '||TO_CHAR(g_paye_element_id));