APPS.HR_PERSON_RECORD dependencies on PER_ASSIGNMENTS_F

Line 36: p_emplmt_category per_assignments_f2.employee_category%type default null;

32: srch_filtrd srch_filtered;
33:
34: -- temporary record for ease of access
35: p_bus_group_id number default null;
36: p_emplmt_category per_assignments_f2.employee_category%type default null;
37: p_empl_category per_assignments_f2.EMPLOYMENT_CATEGORY%type default null;
38:
39: -- temporary record for ease of access
40: -- cursor to fetch the person records

Line 37: p_empl_category per_assignments_f2.EMPLOYMENT_CATEGORY%type default null;

33:
34: -- temporary record for ease of access
35: p_bus_group_id number default null;
36: p_emplmt_category per_assignments_f2.employee_category%type default null;
37: p_empl_category per_assignments_f2.EMPLOYMENT_CATEGORY%type default null;
38:
39: -- temporary record for ease of access
40: -- cursor to fetch the person records
41: cursor csr_person_record(p_person_id number,p_business_group_id number,p_eff_date date) is

Line 435: , '' POSTING_CONTENT_ID -- column not exist in PER_ASSIGNMENTS_F2

431: and nvl(end_date_active,p_eff_Date)
432: and enabled_flag = 'Y') EMPLOYEE_CATEGORY_DESC
433: , WORK_AT_HOME
434: , JOB_POST_SOURCE_NAME
435: , '' POSTING_CONTENT_ID -- column not exist in PER_ASSIGNMENTS_F2
436: , to_char(PERIOD_OF_PLACEMENT_DATE_START,'YYYY-MM-DD')
437: , VENDOR_ID
438: , VENDOR_EMPLOYEE_NUMBER
439: , VENDOR_ASSIGNMENT_NUMBER

Line 442: , '' APPLICANT_RANK -- column not exist in PER_ASSIGNMENTS_F2

438: , VENDOR_EMPLOYEE_NUMBER
439: , VENDOR_ASSIGNMENT_NUMBER
440: , ASSIGNMENT_CATEGORY
441: , PROJECT_TITLE
442: , '' APPLICANT_RANK -- column not exist in PER_ASSIGNMENTS_F2
443: , VENDOR_SITE_ID
444: , PO_HEADER_ID
445: , PO_LINE_ID
446: , PROJECTED_ASSIGNMENT_END

Line 450: FROM PER_ASSIGNMENTS_F2 paaf,

446: , PROJECTED_ASSIGNMENT_END
447: , GRADE_LADDER_PGM_ID
448: , '' GRADE_LADDER_PGM_NAME
449: , SUPERVISOR_ASSIGNMENT_ID
450: FROM PER_ASSIGNMENTS_F2 paaf,
451: PER_ASSIGNMENT_STATUS_TYPES ST ,
452: PER_ASSIGNMENT_STATUS_TYPES_TL STTL
453: WHERE paaf.person_id = p_person_id
454: AND paaf.business_group_id = p_business_group_id

Line 1162: WHERE assignment_id in (SELECT assignment_id from PER_ASSIGNMENTS_F

1158: , AEI_INFORMATION28
1159: , AEI_INFORMATION29
1160: , AEI_INFORMATION30
1161: FROM PER_ASSIGNMENT_EXTRA_INFO
1162: WHERE assignment_id in (SELECT assignment_id from PER_ASSIGNMENTS_F
1163: WHERE person_id = p_person_id
1164: and business_group_id = p_business_group_id
1165: and p_eff_date between effective_start_date and nvl(effective_end_date,to_date('31/12/4712','Dd/MM/YYYY')));
1166:

Line 1457: FROM per_assignments_f papf , per_people_f ppf

1453: papf.assignment_status_type_id,
1454: (SELECT USER_STATUS FROM PER_ASSIGNMENT_STATUS_TYPES_TL
1455: WHERE ASSIGNMENT_STATUS_TYPE_ID = papf.assignment_status_type_id
1456: AND LANGUAGE = USERENV('LANG')) REPORTEE_ASG_STATUS_DESC
1457: FROM per_assignments_f papf , per_people_f ppf
1458: WHERE
1459: p_eff_date BETWEEN papf.effective_start_date AND papf.effective_end_date
1460: and p_eff_date BETWEEN ppf.effective_start_date AND ppf.effective_end_date
1461: and papf.business_group_id = P_BUSINESS_GROUP_ID

Line 1668: from per_people_f ppf ,per_person_types ppt ,per_assignments_f paaf

1664: ELSE
1665: open srch_filtrd for
1666:
1667: select distinct ppf.person_id ,ppf.business_group_id,p_srch_criteria(i).p_effective_date
1668: from per_people_f ppf ,per_person_types ppt ,per_assignments_f paaf
1669: where nvl(p_srch_criteria(i).p_person_id, ppf.person_id) = ppf.person_id
1670: and ppf.person_id between nvl(p_srch_criteria(i).p_start_person_id, ppf.person_id)
1671: and nvl(p_srch_criteria(i).p_end_person_id, ppf.person_id)
1672: and ppf.business_group_id = nvl(p_bus_group_id,ppf.business_group_id)