[Home] [Help]
95: paf.location_id LOCATION_ID,
96: paf.organization_id ORGANIZATION_ID,
97: paf.business_group_id BUSINESS_GROUP_ID,
98: punits.name ORGANIZATION_NAME
99: from per_assignments_f paf,
100: per_people_f ppf,
101: per_person_types ppt,
102: per_organization_units punits
103: -- VSM added nvl( .. to the start... clause
135: paf.location_id LOCATION_ID,
136: paf.organization_id ORGANIZATION_ID,
137: paf.business_group_id BUSINESS_GROUP_ID,
138: punits.name ORGANIZATION_NAME
139: from per_assignments_f paf,
140: per_people_f ppf,
141: per_person_types ppt,
142: per_organization_units punits
143: WHERE (paf.position_id = nvl(p_org_pos_id,paf.position_id)
190: pop.position_id = nvl(p_org_pos_id,pop.position_id) and org_pos_fl = 'P')
191: and not exists
192: (
193: SELECT 'X'
194: FROM per_people_f p, per_assignments_f a
195: WHERE trunc(effective_DATE) between a.effective_start_DATE and a.effective_END_DATE
196: AND a.primary_flag = 'Y'
197: AND a.assignment_type <> 'B'
198: AND p.current_employee_flag = 'Y'
233: between effective_start_DATE and effective_END_DATE
234: and business_group_id = g_business_group_id
235: MINUS
236: SELECT a.position_id
237: from per_people_f p, per_assignments_f a
238: WHERE (a.organization_id = nvl(p_org_pos_id,organization_id) and org_pos_fl = 'O'
239: or
240: a.position_id = nvl(p_org_pos_id,a.position_id) and org_pos_fl = 'P')
241: and trunc(effective_DATE) between a.effective_start_DATE
293: from HR_ORGANIZATION_INFORMATION
294: WHERE organization_id = p_organization_id
295: and ORG_INFORMATION_CONTEXT = 'GHR_US_ORG_REPORTING_INFO';
296:
297: l_assignment_id per_assignments_f.assignment_id%type;
298: l_position_id per_assignments_f.position_id%type;
299: l_grade_id per_assignments_f.grade_id%type;
300: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
301: l_business_group_id per_assignments_f.business_group_id%type;
294: WHERE organization_id = p_organization_id
295: and ORG_INFORMATION_CONTEXT = 'GHR_US_ORG_REPORTING_INFO';
296:
297: l_assignment_id per_assignments_f.assignment_id%type;
298: l_position_id per_assignments_f.position_id%type;
299: l_grade_id per_assignments_f.grade_id%type;
300: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
301: l_business_group_id per_assignments_f.business_group_id%type;
302:
295: and ORG_INFORMATION_CONTEXT = 'GHR_US_ORG_REPORTING_INFO';
296:
297: l_assignment_id per_assignments_f.assignment_id%type;
298: l_position_id per_assignments_f.position_id%type;
299: l_grade_id per_assignments_f.grade_id%type;
300: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
301: l_business_group_id per_assignments_f.business_group_id%type;
302:
303: l_position_title VARCHAR2(300);
297: l_assignment_id per_assignments_f.assignment_id%type;
298: l_position_id per_assignments_f.position_id%type;
299: l_grade_id per_assignments_f.grade_id%type;
300: l_asg_extra_info_rec per_assignment_extra_info%rowtype;
301: l_business_group_id per_assignments_f.business_group_id%type;
302:
303: l_position_title VARCHAR2(300);
304: l_position_NUMBER VARCHAR2(20);
305: l_position_seq_no VARCHAR2(20);
2827: --
2828: --
2829:
2830: procedure get_pos_grp1_ddf (p_position_id in
2831: per_assignments_f.position_id%type,
2832: p_effective_DATE in DATE,
2833: p_personnel_office_id out NOCOPY VARCHAR2,
2834: p_org_structure_id out NOCOPY VARCHAR2,
2835: p_office_symbol out NOCOPY VARCHAR2,
2879: --
2880: --
2881:
2882: procedure get_pos_grp2_ddf (p_position_id in
2883: per_assignments_f.position_id%type,
2884: p_effective_DATE in DATE,
2885: p_org_func_code out NOCOPY VARCHAR2,
2886: p_appropriation_code1 out NOCOPY VARCHAR2,
2887: p_appropriation_code2 out NOCOPY VARCHAR2)
3185: p_employee_number in VARCHAR2,
3186: p_duty_station_code in VARCHAR2,
3187: p_duty_station_desc in VARCHAR2,
3188: p_personnel_office_id in VARCHAR2,
3189: p_position_id in per_assignments_f.position_id%type,
3190: p_position_title in VARCHAR2,
3191: p_position_NUMBER in VARCHAR2,
3192: p_position_seq_no in VARCHAR2,
3193: p_org_structure_id in VARCHAR2,