APPS.GHR_MTO_PKG dependencies on PER_ASSIGNMENTS_F

Line 225: from per_assignments_f paf,

221: paf.location_id LOCATION_ID,
222: paf.organization_id ORGANIZATION_ID,
223: paf.business_group_id BUSINESS_GROUP_ID,
224: punits.name ORGANIZATION_NAME
225: from per_assignments_f paf,
226: per_people_f ppf,
227: per_person_types ppt,
228: per_organization_units punits
229: -- VSM added nvl( .. to the start... clause

Line 268: from per_assignments_f paf,

264: paf.location_id LOCATION_ID,
265: paf.organization_id ORGANIZATION_ID,
266: paf.business_group_id BUSINESS_GROUP_ID,
267: punits.name ORGANIZATION_NAME
268: from per_assignments_f paf,
269: per_people_f ppf,
270: per_person_types ppt,
271: per_organization_units punits
272: where (paf.position_id = nvl(p_org_id,paf.position_id)

Line 331: from per_people_f p, per_assignments_f a

327: OR
328: p_agency is null)
329: MINUS
330: select a.position_id
331: from per_people_f p, per_assignments_f a
332: where (a.organization_id = nvl(p_org_id,organization_id) and org_pos_fl = 'O'
333: or a.position_id = nvl(p_org_id,position_id) and org_pos_fl = 'P')
334: and trunc(effective_date) between a.effective_start_date
335: and a.effective_end_date

Line 393: l_assignment_id per_assignments_f.assignment_id%type;

389: l_dummy varchar2(35);
390: l_agency_code ghr_pa_requests.agency_code%type;
391: --------
392:
393: l_assignment_id per_assignments_f.assignment_id%type;
394: l_position_id per_assignments_f.position_id%type;
395: l_grade_id per_assignments_f.grade_id%type;
396: --l_grade_id number;
397:

Line 394: l_position_id per_assignments_f.position_id%type;

390: l_agency_code ghr_pa_requests.agency_code%type;
391: --------
392:
393: l_assignment_id per_assignments_f.assignment_id%type;
394: l_position_id per_assignments_f.position_id%type;
395: l_grade_id per_assignments_f.grade_id%type;
396: --l_grade_id number;
397:
398: l_business_group_id per_assignments_f.business_group_id%type;

Line 395: l_grade_id per_assignments_f.grade_id%type;

391: --------
392:
393: l_assignment_id per_assignments_f.assignment_id%type;
394: l_position_id per_assignments_f.position_id%type;
395: l_grade_id per_assignments_f.grade_id%type;
396: --l_grade_id number;
397:
398: l_business_group_id per_assignments_f.business_group_id%type;
399:

Line 398: l_business_group_id per_assignments_f.business_group_id%type;

394: l_position_id per_assignments_f.position_id%type;
395: l_grade_id per_assignments_f.grade_id%type;
396: --l_grade_id number;
397:
398: l_business_group_id per_assignments_f.business_group_id%type;
399:
400: l_position_title varchar2(300);
401: l_position_number varchar2(20);
402: l_position_seq_no varchar2(20);

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

2150: --
2151: --
2152: --
2153:
2154: procedure get_pos_grp1_ddf (p_position_id in per_assignments_f.position_id%type,
2155: p_effective_date in date,
2156: p_personnel_office_id out NOCOPY varchar2,
2157: p_org_structure_id out NOCOPY varchar2,
2158: p_office_symbol out NOCOPY varchar2,

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

2218: --
2219: --
2220: --
2221:
2222: procedure get_pos_grp2_ddf (p_position_id in per_assignments_f.position_id%type,
2223: p_effective_date in date,
2224: p_org_func_code out NOCOPY varchar2,
2225: p_appropriation_code1 out NOCOPY varchar2,
2226: p_appropriation_code2 out NOCOPY varchar2,

Line 2353: p_position_id in per_assignments_f.position_id%type,

2349: p_employee_number in varchar2,
2350: p_duty_station_code in varchar2,
2351: p_duty_station_desc in varchar2,
2352: p_personnel_office_id in varchar2,
2353: p_position_id in per_assignments_f.position_id%type,
2354: p_position_title in varchar2,
2355: p_position_number in varchar2,
2356: p_position_seq_no in varchar2,
2357: p_org_structure_id in varchar2,