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 4149: from per_all_assignments_f asg,hr_locations_all loc

4145: -- US legislation code.
4146: --
4147: cursor c_asg is
4148: select asg.assignment_id,asg.organization_id,loc.region_2
4149: from per_all_assignments_f asg,hr_locations_all loc
4150: where asg.assignment_id = p_assignment_id
4151: and asg.primary_flag = 'Y'
4152: and asg.location_id = loc.location_id(+)
4153: and p_effective_date

Line 4592: from per_all_assignments_f paf

4588: --ud changes start
4589:
4590: cursor c1 is
4591: select paf.*
4592: from per_all_assignments_f paf
4593: where paf.person_id = p_person_id
4594: and paf.business_group_id = p_business_group_id
4595: and paf.primary_flag = 'Y'
4596: and paf.assignment_type = 'E'

Line 4606: l_ass_rec per_all_assignments_f%rowtype;

4602:
4603: l_package varchar2(80) := g_package||'.run_rule';
4604: l_outputs ff_exec.outputs_t;
4605: l_loc_rec hr_locations_all%rowtype;
4606: l_ass_rec per_all_assignments_f%rowtype;
4607: l_jurisdiction_code varchar2(30);
4608: l_env ben_env_object.g_global_env_rec_type;
4609: --
4610: begin

Line 5258: from per_all_assignments_f asg

5254: and cur.CURRENCY_CODE(+) = pl.nip_pl_uom
5255: ;
5256: CURSOR c_pay_basis IS
5257: select ppb.pay_annualization_factor
5258: from per_all_assignments_f asg
5259: ,per_pay_bases ppb
5260: where asg.assignment_id = p_assignment_id
5261: and p_effective_date between asg.effective_start_date
5262: and asg.effective_end_date

Line 5344: from per_all_assignments_f asg

5340: and cur.CURRENCY_CODE(+) = pl.nip_pl_uom
5341: ;
5342: CURSOR c_pay_basis IS
5343: select ppb.pay_annualization_factor
5344: from per_all_assignments_f asg
5345: ,per_pay_bases ppb
5346: where asg.assignment_id = p_assignment_id
5347: and p_effective_date between asg.effective_start_date
5348: and asg.effective_end_date

Line 5898: from per_all_assignments_f

5894: where person_id = p_person_id
5895: and business_group_id = p_business_group_id
5896: union
5897: select max(nvl(last_update_date,p_pil_last_upd_date)) last_update_date
5898: from per_all_assignments_f
5899: where person_id = p_person_id
5900: and business_group_id = p_business_group_id
5901: union
5902: select max(nvl(last_update_date,p_pil_last_upd_date)) last_update_date

Line 5913: from per_pay_proposals psl, per_all_assignments_f asn

5909: where person_id = p_person_id
5910: and business_group_id = p_business_group_id
5911: union
5912: select max(nvl(psl.last_update_date,p_pil_last_upd_date)) last_update_date
5913: from per_pay_proposals psl, per_all_assignments_f asn
5914: where psl.assignment_id = asn.assignment_id
5915: and asn.person_id = p_person_id
5916: and asn.business_group_id = p_business_group_id
5917: union