[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
412: and nvl(end_date_active,p_eff_Date)
413: and enabled_flag = 'Y') EMPLOYEE_CATEGORY_DESC
414: , WORK_AT_HOME
415: , JOB_POST_SOURCE_NAME
416: , '' POSTING_CONTENT_ID -- column not exist in PER_ASSIGNMENTS_F2
417: , to_char(PERIOD_OF_PLACEMENT_DATE_START,'YYYY-MM-DD')
418: , VENDOR_ID
419: , VENDOR_EMPLOYEE_NUMBER
420: , VENDOR_ASSIGNMENT_NUMBER
419: , VENDOR_EMPLOYEE_NUMBER
420: , VENDOR_ASSIGNMENT_NUMBER
421: , ASSIGNMENT_CATEGORY
422: , PROJECT_TITLE
423: , '' APPLICANT_RANK -- column not exist in PER_ASSIGNMENTS_F2
424: , VENDOR_SITE_ID
425: , PO_HEADER_ID
426: , PO_LINE_ID
427: , PROJECTED_ASSIGNMENT_END
427: , PROJECTED_ASSIGNMENT_END
428: , GRADE_LADDER_PGM_ID
429: , '' GRADE_LADDER_PGM_NAME
430: , SUPERVISOR_ASSIGNMENT_ID
431: FROM PER_ASSIGNMENTS_F2 paaf,
432: PER_ASSIGNMENT_STATUS_TYPES ST ,
433: PER_ASSIGNMENT_STATUS_TYPES_TL STTL
434: WHERE paaf.person_id = p_person_id
435: AND paaf.business_group_id = p_business_group_id