APPS.PAY_GB_PAYE_SYNC dependencies on PAY_ELEMENT_TYPES_F

Line 19: l_ele_type_id pay_element_types_f.element_type_id%type;

15: l_count number;
16:
17: l_person_id per_all_people_f.person_id%type := -1;
18: l_tax_code_id pay_input_values_f.input_value_id%type;
19: l_ele_type_id pay_element_types_f.element_type_id%type;
20: l_tax_basis_id pay_input_values_f.input_value_id%type;
21:
22: l_sft_coding_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;
23: l_last_person_id per_all_people_f.person_id%type := -1;

Line 58: FROM pay_element_types_f petf

54: -- Fetch the PAYE Details element details
55: CURSOR c_ele_typ_id(c_eff_date date)
56: IS
57: SELECT petf.element_type_id
58: FROM pay_element_types_f petf
59: WHERE petf.element_name = 'PAYE Details'
60: AND petf.legislation_code = 'GB'
61: AND c_eff_date between petf.effective_start_date and petf.effective_end_date;
62:

Line 208: pay_element_types_f elt,

204: FROM pay_element_entries_f ele,
205: pay_element_entry_values_f eev,
206: pay_input_values_f inv,
207: pay_element_links_f lnk,
208: pay_element_types_f elt,
209: pay_all_payrolls_f papf,
210: per_all_assignments_f paaf,
211: hr_soft_coding_keyflex hsck
212: WHERE ele.element_entry_id = eev.element_entry_id

Line 689: from pay_element_types_f

685:
686: cursor get_element_type_id
687: is
688: select element_type_id
689: from pay_element_types_f
690: where element_name = 'PAYE Details'
691: and legislation_code = 'GB';
692:
693: cursor csr_db_paye_det(P_IN_ASSIGNMENT_ID number,