APPS.PAY_IE_P35_MAGTAPE dependencies on PAY_ALL_PAYROLLS_F

Line 170: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;

166: l_end_date DATE;
167: l_bg_id NUMBER;
168: l_segment4 hr_soft_coding_keyflex.segment4%TYPE;
169: l_assignment_set_id hr_assignment_sets.assignment_set_id%TYPE;
170: l_payroll_id pay_all_payrolls_f.payroll_id%TYPE;
171: l_set_flag hr_assignment_set_amendments.include_or_exclude%TYPE ;
172:
173: CURSOR csr_get_flag_from_set
174: IS

Line 188: pay_all_payrolls_f ppf,

184: FROM pay_assignment_actions paa,
185: pay_payroll_actions ppa,
186: pay_action_information pai,
187: per_assignments_f paaf,
188: pay_all_payrolls_f ppf,
189: hr_soft_coding_keyflex flex
190: WHERE paa.payroll_action_id = ppa.payroll_action_id
191: AND paa.action_status = 'C'
192: AND ppa.action_type ='X'

Line 263: pay_all_payrolls_f ppf_p35,

259: SELECT 1
260: FROM pay_assignment_actions paa_p35,
261: pay_payroll_actions ppa_p35,
262: per_assignments_f paaf_p35,
263: pay_all_payrolls_f ppf_p35,
264: hr_soft_coding_keyflex flex_p35,
265: pay_action_interlocks plock
266: WHERE ppa_p35.report_type = 'IEP35MAG'
267: AND paa_p35.action_status = 'C'