APPS.BENUTILS dependencies on PER_ALL_ASSIGNMENTS_F

Line 668: from per_all_assignments_f paf, per_assignment_status_types pat

664: l_assignment_id number;
665: --
666: cursor c_assignment is
667: select paf.assignment_id
668: from per_all_assignments_f paf, per_assignment_status_types pat
669: where paf.primary_flag = 'Y'
670: and paf.assignment_type <> 'C'
671: and paf.business_group_id = p_business_group_id
672: and paf.person_id = p_person_id

Line 676: and hr_security.show_record ('PER_ALL_ASSIGNMENTS_F',

672: and paf.person_id = p_person_id
673: and paf.assignment_status_type_id = pat.assignment_status_type_id(+)
674: and pat.per_system_status(+) = 'ACTIVE_ASSIGN'
675: and p_effective_date between paf.effective_start_date and paf.effective_end_date
676: and hr_security.show_record ('PER_ALL_ASSIGNMENTS_F',
677: paf.assignment_id,
678: paf.person_id,
679: paf.assignment_type
680: )

Line 686: from per_all_assignments_f paf, per_assignment_status_types pat

682: order by assignment_type desc, effective_start_date desc;
683: --
684: cursor c_all_assignment is
685: select paf.assignment_id
686: from per_all_assignments_f paf, per_assignment_status_types pat
687: where paf.primary_flag = 'Y'
688: and paf.assignment_type <> 'C'
689: and paf.business_group_id = p_business_group_id
690: and paf.person_id = p_person_id

Line 4053: from per_all_assignments_f asg,hr_locations_all loc

4049: -- US legislation code.
4050: --
4051: cursor c_asg is
4052: select asg.assignment_id,asg.organization_id,loc.region_2
4053: from per_all_assignments_f asg,hr_locations_all loc
4054: where asg.assignment_id = p_assignment_id
4055: and asg.primary_flag = 'Y'
4056: and asg.location_id = loc.location_id(+)
4057: and p_effective_date

Line 4494: l_ass_rec per_all_assignments_f%rowtype;

4490:
4491: l_package varchar2(80) := g_package||'.run_rule';
4492: l_outputs ff_exec.outputs_t;
4493: l_loc_rec hr_locations_all%rowtype;
4494: l_ass_rec per_all_assignments_f%rowtype;
4495: l_jurisdiction_code varchar2(30);
4496: l_env ben_env_object.g_global_env_rec_type;
4497: --
4498: begin

Line 5133: from per_all_assignments_f asg

5129: and cur.CURRENCY_CODE(+) = pl.nip_pl_uom
5130: ;
5131: CURSOR c_pay_basis IS
5132: select ppb.pay_annualization_factor
5133: from per_all_assignments_f asg
5134: ,per_pay_bases ppb
5135: where asg.assignment_id = p_assignment_id
5136: and p_effective_date between asg.effective_start_date
5137: and asg.effective_end_date

Line 5219: from per_all_assignments_f asg

5215: and cur.CURRENCY_CODE(+) = pl.nip_pl_uom
5216: ;
5217: CURSOR c_pay_basis IS
5218: select ppb.pay_annualization_factor
5219: from per_all_assignments_f asg
5220: ,per_pay_bases ppb
5221: where asg.assignment_id = p_assignment_id
5222: and p_effective_date between asg.effective_start_date
5223: and asg.effective_end_date

Line 5773: from per_all_assignments_f

5769: where person_id = p_person_id
5770: and business_group_id = p_business_group_id
5771: union
5772: select max(nvl(last_update_date,p_pil_last_upd_date)) last_update_date
5773: from per_all_assignments_f
5774: where person_id = p_person_id
5775: and business_group_id = p_business_group_id
5776: union
5777: select max(nvl(last_update_date,p_pil_last_upd_date)) last_update_date

Line 5788: from per_pay_proposals psl, per_all_assignments_f asn

5784: where person_id = p_person_id
5785: and business_group_id = p_business_group_id
5786: union
5787: select max(nvl(psl.last_update_date,p_pil_last_upd_date)) last_update_date
5788: from per_pay_proposals psl, per_all_assignments_f asn
5789: where psl.assignment_id = asn.assignment_id
5790: and asn.person_id = p_person_id
5791: and asn.business_group_id = p_business_group_id
5792: union