[Home] [Help]
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
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
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
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
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