APPS.PAY_GENERIC_UPGRADE dependencies on PER_ALL_ASSIGNMENTS_F

Line 395: per_all_assignments_f asg,

391:
392: if sqlstr is null then
393: sqlstr := 'select distinct asg.person_id
394: from
395: per_all_assignments_f asg,
396: pay_payroll_actions pa1
397: where pa1.payroll_action_id = :payroll_action_id
398: and asg.business_group_id = pa1.business_group_id
399: order by asg.person_id';

Line 406: per_all_assignments_f asg,

402: elsif (l_upg_level = 'L') then
403: --
404: sqlstr := 'select distinct asg.person_id
405: from
406: per_all_assignments_f asg,
407: pay_payroll_actions pa1,
408: per_business_groups_perf pbg1,
409: per_business_groups_perf pbg
410: where pa1.payroll_action_id = :payroll_action_id

Line 420: per_all_assignments_f asg,

416: elsif (l_upg_level = 'G') then
417: --
418: sqlstr := 'select distinct asg.person_id
419: from
420: per_all_assignments_f asg,
421: pay_payroll_actions pa1
422: where pa1.payroll_action_id = :payroll_action_id
423: order by asg.person_id';
424: --

Line 614: per_all_assignments_f paf,

610: cp_endperson number
611: ) is
612: select distinct paf.assignment_id
613: from
614: per_all_assignments_f paf,
615: pay_payroll_actions ppa
616: where ppa.payroll_action_id = cp_pactid
617: and ppa.business_group_id = paf.business_group_id
618: and paf.person_id between cp_stperson and cp_endperson;

Line 625: per_all_assignments_f paf,

621: c_chunk number
622: ) is
623: select distinct paf.assignment_id
624: from
625: per_all_assignments_f paf,
626: pay_payroll_actions ppa,
627: pay_population_ranges ppr
628: where ppr.chunk_number = c_chunk
629: and ppr.payroll_action_id = ppa.payroll_action_id

Line 668: per_all_assignments_f paf,

664: cp_endperson number
665: ) is
666: select distinct paf.assignment_id
667: from
668: per_all_assignments_f paf,
669: pay_payroll_actions ppa,
670: per_business_groups_perf pbg,
671: per_business_groups_perf pbg1
672: where ppa.payroll_action_id = cp_pactid

Line 711: per_all_assignments_f paf

707: cp_endperson number
708: ) is
709: select distinct paf.assignment_id
710: from
711: per_all_assignments_f paf
712: where paf.person_id between cp_stperson and cp_endperson;
713: --
714: cursor c_glo_pet (
715: cp_stetid number,