[Home] [Help]
93: paf.location_id LOCATION_ID,
94: paf.organization_id ORGANIZATION_ID,
95: paf.business_group_id BUSINESS_GROUP_ID,
96: punits.name ORGANIZATION_NAME
97: from per_assignments_f paf,
98: per_people_f ppf,
99: per_person_types ppt,
100: per_organization_units punits
101: -- VSM added nvl( .. to the start... clause
131: paf.location_id LOCATION_ID,
132: paf.organization_id ORGANIZATION_ID,
133: paf.business_group_id BUSINESS_GROUP_ID,
134: punits.name ORGANIZATION_NAME
135: from per_assignments_f paf,
136: per_people_f ppf,
137: per_person_types ppt,
138: per_organization_units punits
139: WHERE (paf.position_id = nvl(p_org_pos_id,paf.position_id)
184: pop.position_id = nvl(p_org_pos_id,pop.position_id) and org_pos_fl = 'P')
185: and not exists
186: (
187: SELECT 'X'
188: FROM per_people_f p, per_assignments_f a
189: WHERE trunc(effective_DATE) between a.effective_start_DATE and a.effective_END_DATE
190: AND a.primary_flag = 'Y'
191: AND a.assignment_type <> 'B'
192: AND p.current_employee_flag = 'Y'
227: between effective_start_DATE and effective_END_DATE
228: and business_group_id = g_business_group_id
229: MINUS
230: SELECT a.position_id
231: from per_people_f p, per_assignments_f a
232: WHERE (a.organization_id = nvl(p_org_pos_id,organization_id) and org_pos_fl = 'O'
233: or
234: a.position_id = nvl(p_org_pos_id,a.position_id) and org_pos_fl = 'P')
235: and trunc(effective_DATE) between a.effective_start_DATE
287: from HR_ORGANIZATION_INFORMATION
288: WHERE organization_id = p_organization_id
289: and ORG_INFORMATION_CONTEXT = 'GHR_US_ORG_REPORTING_INFO';
290:
291: l_assignment_id per_assignments_f.assignment_id%type;
292: l_position_id per_assignments_f.position_id%type;
293: l_grade_id per_assignments_f.grade_id%type;
294: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
295: l_business_group_id per_assignments_f.business_group_id%type;
288: WHERE organization_id = p_organization_id
289: and ORG_INFORMATION_CONTEXT = 'GHR_US_ORG_REPORTING_INFO';
290:
291: l_assignment_id per_assignments_f.assignment_id%type;
292: l_position_id per_assignments_f.position_id%type;
293: l_grade_id per_assignments_f.grade_id%type;
294: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
295: l_business_group_id per_assignments_f.business_group_id%type;
296:
289: and ORG_INFORMATION_CONTEXT = 'GHR_US_ORG_REPORTING_INFO';
290:
291: l_assignment_id per_assignments_f.assignment_id%type;
292: l_position_id per_assignments_f.position_id%type;
293: l_grade_id per_assignments_f.grade_id%type;
294: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
295: l_business_group_id per_assignments_f.business_group_id%type;
296:
297: l_position_title VARCHAR2(300);
291: l_assignment_id per_assignments_f.assignment_id%type;
292: l_position_id per_assignments_f.position_id%type;
293: l_grade_id per_assignments_f.grade_id%type;
294: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
295: l_business_group_id per_assignments_f.business_group_id%type;
296:
297: l_position_title VARCHAR2(300);
298: l_position_NUMBER VARCHAR2(20);
299: l_position_seq_no VARCHAR2(20);
2666: --
2667: --
2668:
2669: procedure get_pos_grp1_ddf (p_position_id in
2670: per_assignments_f.position_id%type,
2671: p_effective_DATE in DATE,
2672: p_personnel_office_id out NOCOPY VARCHAR2,
2673: p_org_structure_id out NOCOPY VARCHAR2,
2674: p_office_symbol out NOCOPY VARCHAR2,
2718: --
2719: --
2720:
2721: procedure get_pos_grp2_ddf (p_position_id in
2722: per_assignments_f.position_id%type,
2723: p_effective_DATE in DATE,
2724: p_org_func_code out NOCOPY VARCHAR2,
2725: p_appropriation_code1 out NOCOPY VARCHAR2,
2726: p_appropriation_code2 out NOCOPY VARCHAR2)
3022: p_national_identifier in VARCHAR2,
3023: p_duty_station_code in VARCHAR2,
3024: p_duty_station_desc in VARCHAR2,
3025: p_personnel_office_id in VARCHAR2,
3026: p_position_id in per_assignments_f.position_id%type,
3027: p_position_title in VARCHAR2,
3028: p_position_NUMBER in VARCHAR2,
3029: p_position_seq_no in VARCHAR2,
3030: p_org_structure_id in VARCHAR2,