APPS.PAY_GB_PAYE_SYNC dependencies on PAY_ALL_PAYROLLS_F

Line 131: pay_all_payrolls_f pap,

127: pay_element_entries_f peef,
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

Line 209: pay_all_payrolls_f papf,

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
213: AND l_effective_date between ele.effective_start_date and ele.effective_end_date

Line 255: pay_all_payrolls_f papf,

251: paaf.assignment_number,
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

Line 727: pay_all_payrolls_f pap,

723: per_all_assignments_f paaf,
724: pay_element_entries_f peef,
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'