APPS.GHR_MTO_PKG dependencies on PER_ASSIGNMENTS_F

Line 220: from per_assignments_f paf,

216: paf.location_id LOCATION_ID,
217: paf.organization_id ORGANIZATION_ID,
218: paf.business_group_id BUSINESS_GROUP_ID,
219: punits.name ORGANIZATION_NAME
220: from per_assignments_f paf,
221: per_people_f ppf,
222: per_person_types ppt,
223: per_organization_units punits
224: -- VSM added nvl( .. to the start... clause

Line 257: from per_assignments_f paf,

253: paf.location_id LOCATION_ID,
254: paf.organization_id ORGANIZATION_ID,
255: paf.business_group_id BUSINESS_GROUP_ID,
256: punits.name ORGANIZATION_NAME
257: from per_assignments_f paf,
258: per_people_f ppf,
259: per_person_types ppt,
260: per_organization_units punits
261: where (paf.position_id = nvl(p_org_id,paf.position_id)

Line 308: from per_people_f p, per_assignments_f a

304: and trunc(effective_date) between
305: effective_start_date and effective_end_date
306: MINUS
307: select a.position_id
308: from per_people_f p, per_assignments_f a
309: where (a.organization_id = nvl(p_org_id,organization_id) and org_pos_fl = 'O'
310: or a.position_id = nvl(p_org_id,position_id) and org_pos_fl = 'P')
311: and trunc(effective_date) between a.effective_start_date
312: and a.effective_end_date

Line 367: l_assignment_id per_assignments_f.assignment_id%type;

363: l_dummy varchar2(35);
364: l_agency_code ghr_pa_requests.agency_code%type;
365: --------
366:
367: l_assignment_id per_assignments_f.assignment_id%type;
368: l_position_id per_assignments_f.position_id%type;
369: l_grade_id per_assignments_f.grade_id%type;
370: --l_grade_id number;
371:

Line 368: l_position_id per_assignments_f.position_id%type;

364: l_agency_code ghr_pa_requests.agency_code%type;
365: --------
366:
367: l_assignment_id per_assignments_f.assignment_id%type;
368: l_position_id per_assignments_f.position_id%type;
369: l_grade_id per_assignments_f.grade_id%type;
370: --l_grade_id number;
371:
372: l_business_group_id per_assignments_f.business_group_id%type;

Line 369: l_grade_id per_assignments_f.grade_id%type;

365: --------
366:
367: l_assignment_id per_assignments_f.assignment_id%type;
368: l_position_id per_assignments_f.position_id%type;
369: l_grade_id per_assignments_f.grade_id%type;
370: --l_grade_id number;
371:
372: l_business_group_id per_assignments_f.business_group_id%type;
373:

Line 372: l_business_group_id per_assignments_f.business_group_id%type;

368: l_position_id per_assignments_f.position_id%type;
369: l_grade_id per_assignments_f.grade_id%type;
370: --l_grade_id number;
371:
372: l_business_group_id per_assignments_f.business_group_id%type;
373:
374: l_position_title varchar2(300);
375: l_position_number varchar2(20);
376: l_position_seq_no varchar2(20);

Line 2047: procedure get_pos_grp1_ddf (p_position_id in per_assignments_f.position_id%type,

2043: --
2044: --
2045: --
2046:
2047: procedure get_pos_grp1_ddf (p_position_id in per_assignments_f.position_id%type,
2048: p_effective_date in date,
2049: p_personnel_office_id out NOCOPY varchar2,
2050: p_org_structure_id out NOCOPY varchar2,
2051: p_office_symbol out NOCOPY varchar2,

Line 2115: procedure get_pos_grp2_ddf (p_position_id in per_assignments_f.position_id%type,

2111: --
2112: --
2113: --
2114:
2115: procedure get_pos_grp2_ddf (p_position_id in per_assignments_f.position_id%type,
2116: p_effective_date in date,
2117: p_org_func_code out NOCOPY varchar2,
2118: p_appropriation_code1 out NOCOPY varchar2,
2119: p_appropriation_code2 out NOCOPY varchar2,

Line 2244: p_position_id in per_assignments_f.position_id%type,

2240: p_national_identifier in varchar2,
2241: p_duty_station_code in varchar2,
2242: p_duty_station_desc in varchar2,
2243: p_personnel_office_id in varchar2,
2244: p_position_id in per_assignments_f.position_id%type,
2245: p_position_title in varchar2,
2246: p_position_number in varchar2,
2247: p_position_seq_no in varchar2,
2248: p_org_structure_id in varchar2,