[Home] [Help]
317: l_message VARCHAR2(255);
318: l_action_info_id NUMBER ;
319: l_archived NUMBER ;
320: l_ovn NUMBER ;
321: l_pf_no PER_PEOPLE_F.PER_INFORMATION8%TYPE ;
322: l_nssn PER_PEOPLE_F.PER_INFORMATION15%TYPE ;
323: l_hire_date DATE ;
324: l_emp_type VARCHAR2(2);
325: l_term_date DATE ;
318: l_action_info_id NUMBER ;
319: l_archived NUMBER ;
320: l_ovn NUMBER ;
321: l_pf_no PER_PEOPLE_F.PER_INFORMATION8%TYPE ;
322: l_nssn PER_PEOPLE_F.PER_INFORMATION15%TYPE ;
323: l_hire_date DATE ;
324: l_emp_type VARCHAR2(2);
325: l_term_date DATE ;
326: l_report PER_PERIODS_OF_SERVICE.PDS_INFORMATION1%TYPE;
337: pps.actual_termination_date term_date, -- Termination Date
338: pps.pds_information1 report, -- Termination Reason(Print)
339: pps.pds_information2 efile, -- Termination Reason(EFile)
340: scl.segment12 eps -- EPS on higher employer wages
341: FROM per_people_f ppf,
342: per_person_types ppt,
343: per_assignments_f paf,
344: per_periods_of_service pps,
345: hr_soft_coding_keyflex scl
712: l_base_bus_no VARCHAR2(50) ;
713: l_classification HR_ORGANIZATION_INFORMATION.ORG_INFORMATION3%TYPE ;
714: l_reg_comp_name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION4%TYPE ;
715: l_representative HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
716: l_representative_name PER_PEOPLE_F.FIRST_NAME%TYPE;
717: l_representative_desig PER_ALL_POSITIONS.NAME%TYPE;
718: l_bus_group_id VARCHAR2(20);
719:
720:
765: IS
766: SELECT DECODE(pep.title,NULL,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title)
767: ,SUBSTR(hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title)
768: ,INSTR(hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title),' ',1)+1)) name
769: FROM per_people_f pep
770: WHERE pep.person_id = p_person_id
771: AND g_end_date BETWEEN pep.effective_start_date AND pep.effective_end_date ;
772:
773: