APPS.PAY_YEAR_END_EXTRACT dependencies on PAY_ELEMENT_TYPES_F

Line 186: pay_element_types_f where element_name = 'NI'

182: BEGIN
183: -- if global ids arent set set them
184: if g_ni_id is null then
185: select element_type_id into g_ni_id from
186: pay_element_types_f where element_name = 'NI'
187: and p_effective_date between
188: effective_start_date and effective_end_date;
189: --
190: select input_value_id into g_category_input_id from

Line 772: pay_element_types_f where element_name = 'PAYE Details'

768: fetch get_defined_balance_id into l_taxable_id;
769: close get_defined_balance_id;
770: --
771: select element_type_id into l_paye_details_id from
772: pay_element_types_f where element_name = 'PAYE Details'
773: and l_end_year between
774: effective_start_date and effective_end_date;
775: --
776: select 10 * pay_run_results_s.nextval

Line 781: pay_element_types_f where element_name = 'NI'

777: into l_max_run_result_id
778: from dual;
779: --
780: select element_type_id into l_ni_id from
781: pay_element_types_f where element_name = 'NI'
782: and l_end_year between
783: effective_start_date and effective_end_date;
784: --
785: select input_value_id into l_category_input_id from