APPS.PAY_CA_RL2_CAN_MAG dependencies on PER_ALL_ASSIGNMENTS_F

Line 249: from per_all_assignments_f paaf,

245:
246: hr_utility.set_location( 'pay_ca_rl2_can_mag.range_cursor', 20);
247:
248: p_sqlstr := 'select distinct paaf.person_id
249: from per_all_assignments_f paaf,
250: pay_payroll_actions ppa,
251: pay_payroll_actions ppa1,
252: pay_assignment_actions paa
253: where ppa.payroll_action_id = paa.payroll_action_id

Line 302: per_all_assignments_f paaf,

298: paaf.effective_end_date,
299: paa.assignment_action_id,
300: ppa2.payroll_action_id
301: from
302: per_all_assignments_f paaf,
303: pay_payroll_actions ppa,
304: pay_payroll_actions ppa1,
305: pay_payroll_actions ppa2,
306: pay_assignment_actions paa,

Line 330: from per_all_assignments_f paaf2

326: to_number(pay_ca_rl2_can_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))
327: )
328: -- and paaf.effective_start_date condition added for bug 9142143
329: and paaf.effective_start_date = (select max(paaf2.effective_start_date)
330: from per_all_assignments_f paaf2
331: where paaf2.assignment_id = paa.assignment_id
332: and paaf2.effective_start_date <= ppa.effective_date);
333:
334: CURSOR c_all_asg_in_asgset IS

Line 342: per_all_assignments_f paaf,

338: paaf.effective_end_date,
339: paa.assignment_action_id,
340: ppa2.payroll_action_id
341: from
342: per_all_assignments_f paaf,
343: pay_payroll_actions ppa,
344: pay_payroll_actions ppa1,
345: pay_payroll_actions ppa2,
346: pay_assignment_actions paa,

Line 377: from per_all_assignments_f paaf2

373: to_number(pay_ca_rl2_can_mag.get_parameter('PAY_ACT', ppa1.legislative_parameters))
374: )
375: -- and paaf.effective_start_date condition added for bug 9142143
376: and paaf.effective_start_date = (select max(paaf2.effective_start_date)
377: from per_all_assignments_f paaf2
378: where paaf2.assignment_id = paa.assignment_id
379: and paaf2.effective_start_date <= ppa.effective_date);
380:
381: l_year_start DATE;

Line 1381: per_all_assignments_f paf,

1377: pay_magtape_generic.date_earned(ppa.effective_date,paf.assignment_id),
1378: pay_ca_rl2_can_mag.get_parameter('PRE_ORGANIZATION_ID',ppa_arch.legislative_parameters)
1379: FROM
1380: per_all_people_f ppf,
1381: per_all_assignments_f paf,
1382: pay_action_interlocks pai_mag,
1383: pay_action_interlocks pai_arch,
1384: pay_payroll_actions ppa,
1385: pay_payroll_actions ppa_arch,