APPS.PAY_IN_PF_ARCHIVE dependencies on PER_PEOPLE_F

Line 323: l_pf_no PER_PEOPLE_F.PER_INFORMATION8%TYPE ;

319: l_message VARCHAR2(255);
320: l_action_info_id NUMBER ;
321: l_archived NUMBER ;
322: l_ovn NUMBER ;
323: l_pf_no PER_PEOPLE_F.PER_INFORMATION8%TYPE ;
324: l_nssn PER_PEOPLE_F.PER_INFORMATION15%TYPE ;
325: l_hire_date DATE ;
326: l_emp_type VARCHAR2(2);
327: l_term_date DATE ;

Line 324: l_nssn PER_PEOPLE_F.PER_INFORMATION15%TYPE ;

320: l_action_info_id NUMBER ;
321: l_archived NUMBER ;
322: l_ovn NUMBER ;
323: l_pf_no PER_PEOPLE_F.PER_INFORMATION8%TYPE ;
324: l_nssn PER_PEOPLE_F.PER_INFORMATION15%TYPE ;
325: l_hire_date DATE ;
326: l_emp_type VARCHAR2(2);
327: l_term_date DATE ;
328: l_report PER_PERIODS_OF_SERVICE.PDS_INFORMATION1%TYPE;

Line 343: FROM per_people_f ppf,

339: pps.actual_termination_date term_date, -- Termination Date
340: pps.pds_information1 report, -- Termination Reason(Print)
341: pps.pds_information2 efile, -- Termination Reason(EFile)
342: scl.segment12 eps -- EPS on higher employer wages
343: FROM per_people_f ppf,
344: per_person_types ppt,
345: per_assignments_f paf,
346: per_periods_of_service pps,
347: hr_soft_coding_keyflex scl

Line 720: l_representative_name PER_PEOPLE_F.FIRST_NAME%TYPE;

716: l_base_bus_no VARCHAR2(50) ;
717: l_classification HR_ORGANIZATION_INFORMATION.ORG_INFORMATION3%TYPE ;
718: l_reg_comp_name HR_ORGANIZATION_INFORMATION.ORG_INFORMATION4%TYPE ;
719: l_representative HR_ORGANIZATION_INFORMATION.ORG_INFORMATION1%TYPE;
720: l_representative_name PER_PEOPLE_F.FIRST_NAME%TYPE;
721: l_representative_desig PER_ALL_POSITIONS.NAME%TYPE;
722: l_bus_group_id VARCHAR2(20);
723:
724:

Line 773: FROM per_people_f pep

769: IS
770: SELECT DECODE(pep.title,NULL,hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title)
771: ,SUBSTR(hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title)
772: ,INSTR(hr_in_utility.per_in_full_name(pep.first_name,pep.middle_names,pep.last_name,pep.title),' ',1)+1)) name
773: FROM per_people_f pep
774: WHERE pep.person_id = p_person_id
775: AND g_end_date BETWEEN pep.effective_start_date AND pep.effective_end_date ;
776:
777: