APPS.HR_PL_UTILITY dependencies on PER_PREVIOUS_EMPLOYERS

Line 626: from per_previous_jobs ppj, per_previous_employers ppe

622: cursor csr_service_period_dts is
623: select ppj.start_date, ppj.end_date,
624: ppj.period_years, ppj.period_months,
625: ppj.period_days
626: from per_previous_jobs ppj, per_previous_employers ppe
627: where ppe.person_id = P_PERSON_ID
628: and ppe.previous_employer_id = ppj.previous_employer_id
629: and ppj.PJO_INFORMATION1 = P_TYPE_OF_SERVICE -- Replaced with PJO_INFORMATION1
630: and ppj.start_date IS NOT NULL

Line 638: from per_previous_jobs ppj, per_previous_employers ppe

634: cursor csr_service_period_ymd is
635: select ppj.start_date, ppj.end_date,
636: ppj.period_years, ppj.period_months,
637: ppj.period_days
638: from per_previous_jobs ppj, per_previous_employers ppe
639: where ppe.person_id = P_PERSON_ID
640: and ppe.previous_employer_id = ppj.previous_employer_id
641: and ppj.PJO_INFORMATION1 = P_TYPE_OF_SERVICE -- Replaced with PJO_INFORMATION1
642: and ppj.start_date IS NULL

Line 968: from PER_PREVIOUS_EMPLOYERS

964: where person_id=r_person_id;
965:
966: cursor csr_pemp_without_start_date(r_person_id per_all_people_f.person_id%type) is
967: select nvl(period_months,0) months,nvl(period_days,0) days,nvl(period_years,0) years
968: from PER_PREVIOUS_EMPLOYERS
969: where person_id=r_person_id
970: and employer_type='PREVIOUS'
971: and start_date is null;
972:

Line 975: from PER_PREVIOUS_EMPLOYERS

971: and start_date is null;
972:
973: cursor csr_prev_emp_with_start_date(r_person_id per_all_people_f.person_id%type) is
974: select start_date ,end_date,period_months,period_days,period_years,employer_type
975: from PER_PREVIOUS_EMPLOYERS
976: where person_id=r_person_id
977: and employer_type in ('PREVIOUS','PARALLEL')
978: and start_date is not null
979: and start_date

Line 1085: /*Calculation start for per_previous_employers*/

1081: hr_utility.set_location(l_proc,20);
1082: /*End of calculation for records in per_periods_of_service*/
1083:
1084:
1085: /*Calculation start for per_previous_employers*/
1086:
1087: /*It involves calculation for 1) (Employer Type :Parallel
1088: or Employer Type :Previous )
1089: and start_date is not null