APPS.PAY_IE_P35_MAGTAPE dependencies on HR_SOFT_CODING_KEYFLEX

Line 168: l_segment4 hr_soft_coding_keyflex.segment4%TYPE;

164: l_out_var VARCHAR2 (30);
165: l_start_date DATE;
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:

Line 189: hr_soft_coding_keyflex flex

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'
193: AND ppa.business_group_id = l_bg_id

Line 233: --, hr_soft_coding_keyflex hflex

229: FROM hr_assignment_set_amendments hasa
230: , hr_assignment_sets has
231: , per_assignments_f paf
232: --, pay_payrolls_f pay
233: --, hr_soft_coding_keyflex hflex
234: WHERE has.assignment_set_id = hasa.assignment_set_id
235: AND has.business_group_id = l_bg_id
236: AND has.assignment_set_id = l_assignment_set_id
237: AND hasa.assignment_id = paf.assignment_id

Line 247: -- , hr_soft_coding_keyflex hflex

243: FROM hr_assignment_set_amendments hasa
244: , hr_assignment_sets has
245: , per_assignments_f paf
246: -- , pay_payrolls_f pay
247: -- , hr_soft_coding_keyflex hflex
248: WHERE has.assignment_set_id = hasa.assignment_set_id
249: AND has.business_group_id = l_bg_id
250: AND has.assignment_set_id = l_assignment_set_id
251: AND hasa.assignment_id = paf.assignment_id

Line 264: hr_soft_coding_keyflex flex_p35,

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'
268: AND TO_DATE (