APPS.PAY_GB_PAYE_SYNC dependencies on HR_SOFT_CODING_KEYFLEX

Line 22: l_sft_coding_id hr_soft_coding_keyflex.soft_coding_keyflex_id%type;

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;
24:
25: l_last_cpe_st_date date;
26:

Line 51: FROM hr_soft_coding_keyflex

47: -- Fetch the Soft coding id for Tax reference
48: CURSOR c_soft_coding_id
49: IS
50: SELECT soft_coding_keyflex_id
51: FROM hr_soft_coding_keyflex
52: WHERE segment1 = l_tax_ref;
53:
54: -- Fetch the PAYE Details element details
55: CURSOR c_ele_typ_id(c_eff_date date)

Line 132: hr_soft_coding_keyflex hsck

128: pay_element_entry_values_f peevf,
129: pay_input_values_f pivf,
130: -- per_assignment_status_types past,
131: pay_all_payrolls_f pap,
132: hr_soft_coding_keyflex hsck
133: where papf.person_id = c_person_id
134: and papf.person_id = paaf.person_id
135: and c_effective_date between papf.effective_start_date and papf.effective_end_date
136: and paaf.assignment_id = peef.assignment_id

Line 211: hr_soft_coding_keyflex hsck

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
213: AND l_effective_date between ele.effective_start_date and ele.effective_end_date
214: AND eev.input_value_id + 0 = inv.input_value_id
215: AND l_effective_date between eev.effective_start_date and eev.effective_end_date

Line 256: hr_soft_coding_keyflex hsck

252: pap.last_name
253: from per_all_people_f pap,
254: per_all_assignments_f paaf,
255: pay_all_payrolls_f papf,
256: hr_soft_coding_keyflex hsck
257: where paaf.person_id = pap.person_id
258: and paaf.person_id = c_person_id
259: and c_effective_date BETWEEN paaf.effective_start_date AND paaf.effective_end_date
260: and c_effective_date BETWEEN pap.effective_start_date AND pap.effective_end_date

Line 729: hr_soft_coding_keyflex flex

725: pay_element_entry_values_f eev,
726: pay_input_values_f inv,
727: pay_all_payrolls_f pap,
728: per_periods_of_service ppos, -- Added for considering Terminated Employees till FPD
729: hr_soft_coding_keyflex flex
730: where paaf.assignment_id = P_IN_ASSIGNMENT_ID
731: and paaf.assignment_type = 'E'
732: and paaf.person_id = papf.person_id
733: and paaf.payroll_id = pap.payroll_id