APPS.PAY_GENERIC_UPGRADE dependencies on PER_ALL_ASSIGNMENTS_F

Line 345: per_all_assignments_f asg,

341: if (l_upg_level = 'B') then
342: --
343: sqlstr := 'select distinct asg.person_id
344: from
345: per_all_assignments_f asg,
346: pay_payroll_actions pa1
347: where pa1.payroll_action_id = :payroll_action_id
348: and asg.business_group_id = pa1.business_group_id
349: order by asg.person_id';

Line 355: per_all_assignments_f asg,

351: elsif (l_upg_level = 'L') then
352: --
353: sqlstr := 'select distinct asg.person_id
354: from
355: per_all_assignments_f asg,
356: pay_payroll_actions pa1,
357: per_business_groups_perf pbg1,
358: per_business_groups_perf pbg
359: where pa1.payroll_action_id = :payroll_action_id

Line 369: per_all_assignments_f asg,

365: elsif (l_upg_level = 'G') then
366: --
367: sqlstr := 'select distinct asg.person_id
368: from
369: per_all_assignments_f asg,
370: pay_payroll_actions pa1
371: where pa1.payroll_action_id = :payroll_action_id
372: order by asg.person_id';
373: --

Line 563: per_all_assignments_f paf,

559: cp_endperson number
560: ) is
561: select distinct paf.assignment_id
562: from
563: per_all_assignments_f paf,
564: pay_payroll_actions ppa
565: where ppa.payroll_action_id = cp_pactid
566: and ppa.business_group_id = paf.business_group_id
567: and paf.person_id between cp_stperson and cp_endperson;

Line 603: per_all_assignments_f paf,

599: cp_endperson number
600: ) is
601: select distinct paf.assignment_id
602: from
603: per_all_assignments_f paf,
604: pay_payroll_actions ppa,
605: per_business_groups_perf pbg,
606: per_business_groups_perf pbg1
607: where ppa.payroll_action_id = cp_pactid

Line 646: per_all_assignments_f paf

642: cp_endperson number
643: ) is
644: select distinct paf.assignment_id
645: from
646: per_all_assignments_f paf
647: where paf.person_id between cp_stperson and cp_endperson;
648: --
649: cursor c_glo_pet (
650: cp_stetid number,