APPS.HR_PL_UTILITY dependencies on PER_PREVIOUS_EMPLOYERS

Line 672: from per_previous_jobs ppj, per_previous_employers ppe

668: cursor csr_service_period_dts is
669: select ppj.start_date, ppj.end_date,
670: ppj.period_years, ppj.period_months,
671: ppj.period_days
672: from per_previous_jobs ppj, per_previous_employers ppe
673: where ppe.person_id = P_PERSON_ID
674: and ppe.previous_employer_id = ppj.previous_employer_id
675: and ppj.PJO_INFORMATION1 = P_TYPE_OF_SERVICE -- Replaced with PJO_INFORMATION1
676: and ppj.start_date IS NOT NULL

Line 684: from per_previous_jobs ppj, per_previous_employers ppe

680: cursor csr_service_period_ymd is
681: select ppj.start_date, ppj.end_date,
682: ppj.period_years, ppj.period_months,
683: ppj.period_days
684: from per_previous_jobs ppj, per_previous_employers ppe
685: where ppe.person_id = P_PERSON_ID
686: and ppe.previous_employer_id = ppj.previous_employer_id
687: and ppj.PJO_INFORMATION1 = P_TYPE_OF_SERVICE -- Replaced with PJO_INFORMATION1
688: and ppj.start_date IS NULL

Line 1014: from PER_PREVIOUS_EMPLOYERS

1010: where person_id=r_person_id;
1011:
1012: cursor csr_pemp_without_start_date(r_person_id per_all_people_f.person_id%type) is
1013: select nvl(period_months,0) months,nvl(period_days,0) days,nvl(period_years,0) years
1014: from PER_PREVIOUS_EMPLOYERS
1015: where person_id=r_person_id
1016: and employer_type='PREVIOUS'
1017: and start_date is null;
1018:

Line 1021: from PER_PREVIOUS_EMPLOYERS

1017: and start_date is null;
1018:
1019: cursor csr_prev_emp_with_start_date(r_person_id per_all_people_f.person_id%type) is
1020: select start_date ,end_date,period_months,period_days,period_years,employer_type
1021: from PER_PREVIOUS_EMPLOYERS
1022: where person_id=r_person_id
1023: and employer_type in ('PREVIOUS','PARALLEL')
1024: and start_date is not null
1025: and start_date

Line 1131: /*Calculation start for per_previous_employers*/

1127: hr_utility.set_location(l_proc,20);
1128: /*End of calculation for records in per_periods_of_service*/
1129:
1130:
1131: /*Calculation start for per_previous_employers*/
1132:
1133: /*It involves calculation for 1) (Employer Type :Parallel
1134: or Employer Type :Previous )
1135: and start_date is not null