APPS.GHR_API dependencies on PER_ALL_ASSIGNMENTS_F

Line 18: from per_all_assignments_f asg

14: -- Private Cursors
15: --
16: cursor c_asg_pos_by_per_id (per_id number, eff_date date) is
17: select asg.position_id
18: from per_all_assignments_f asg
19: where asg.person_id = per_id
20: and asg.assignment_type <> 'B'
21: and trunc(eff_date) between asg.effective_start_date
22: and asg.effective_end_date

Line 27: from per_all_assignments_f asg

23: and asg.primary_flag = 'Y';
24: --
25: cursor c_asg_pos_by_asg_id (asg_id number, eff_date date) is
26: select asg.position_id
27: from per_all_assignments_f asg
28: where asg.assignment_id = asg_id
29: and asg.assignment_type <> 'B'
30: and trunc(eff_date) between asg.effective_start_date
31: and asg.effective_end_date;

Line 35: from per_all_assignments_f asg

31: and asg.effective_end_date;
32: --
33: cursor c_asg_job_by_per_id (per_id number, eff_date date) is
34: select asg.job_id
35: from per_all_assignments_f asg
36: where asg.person_id = per_id
37: and asg.assignment_type <> 'B'
38: and trunc(eff_date) between asg.effective_start_date
39: and asg.effective_end_date

Line 44: from per_all_assignments_f asg

40: and asg.primary_flag = 'Y';
41: --
42: cursor c_asg_job_by_asg_id (asg_id number, eff_date date) is
43: select asg.job_id
44: from per_all_assignments_f asg
45: where asg.assignment_id = asg_id
46: and asg.assignment_type <> 'B'
47: and trunc(eff_date) between asg.effective_start_date
48: and asg.effective_end_date;

Line 118: from per_all_assignments_f asg

114: and per.effective_end_date;
115: --
116: cursor c_assignment (asg_id number, eff_date date) is
117: select asg.business_group_id
118: from per_all_assignments_f asg
119: where asg.assignment_id = asg_id
120: and asg.assignment_type <> 'B'
121: and trunc(eff_date) between asg.effective_start_date
122: and asg.effective_end_date;

Line 185: l_assignment_data per_all_assignments_f%rowtype;

181: ) is
182: --
183: l_result_code varchar2(30);
184: l_people_data per_all_people_f%rowtype;
185: l_assignment_data per_all_assignments_f%rowtype;
186: l_proc varchar2(72) := g_package||'retrieve_business_group_id';
187: Begin
188: if p_person_id is not null then
189: ghr_history_fetch.fetch_people

Line 2690: l_assignment_data per_all_assignments_f%rowtype;

2686: l_org_id hr_organization_units.organization_id%type;
2687: --vsm
2688: l_business_group_id per_business_groups.business_group_id%type;
2689: l_result_code varchar2(30);
2690: l_assignment_data per_all_assignments_f%rowtype;
2691: l_person_type per_person_types.system_person_type%type;
2692: l_effective_date date;
2693: l_assignment_id per_assignments_f.assignment_id%type;
2694: v_assignment_id per_assignments_f.assignment_id%type;

Line 2720: from per_all_assignments_f asg

2716: asg.job_id,
2717: asg.position_id,
2718: asg.grade_id,
2719: asg.location_id
2720: from per_all_assignments_f asg
2721: where asg.person_id = per_id
2722: and asg.assignment_type <> 'B'
2723: and trunc(eff_date) between asg.effective_start_date
2724: and asg.effective_end_date

Line 2733: from per_all_assignments_f asg

2729: asg.job_id,
2730: asg.position_id,
2731: asg.grade_id,
2732: asg.location_id
2733: from per_all_assignments_f asg
2734: where asg.person_id = p_person_id
2735: and asg.assignment_type <> 'B'
2736: and asg.effective_start_date < p_effective_date
2737: and asg.primary_flag = 'Y'

Line 2747: FROM per_all_assignments_f asg

2743: asg.job_id,
2744: asg.position_id,
2745: asg.grade_id,
2746: asg.location_id
2747: FROM per_all_assignments_f asg
2748: WHERE asg.person_id = p_per_id
2749: AND asg.assignment_type <> 'B'
2750: AND trunc(p_eff_date) BETWEEN asg.effective_start_date AND asg.effective_end_date
2751: ORDER BY asg.assignment_id;

Line 2759: from per_all_assignments_f asg

2755: asg.job_id,
2756: asg.position_id,
2757: asg.grade_id,
2758: asg.location_id
2759: from per_all_assignments_f asg
2760: where asg.assignment_id = asg_id
2761: and asg.assignment_type <> 'B'
2762: and trunc(eff_date) between asg.effective_start_date
2763: and asg.effective_end_date;