APPS.HR_PL_UTILITY dependencies on PER_PREVIOUS_JOBS

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 669: total_service_years per_previous_jobs.period_years%TYPE;

665:
666: g_user_service_table_dts service_table;
667: g_user_service_table_ymd service_table;
668:
669: total_service_years per_previous_jobs.period_years%TYPE;
670: total_service_months per_previous_jobs.period_months%TYPE;
671: total_service_days per_previous_jobs.period_days%TYPE;
672: service_type fnd_common_lookups.description%TYPE;
673:

Line 670: total_service_months per_previous_jobs.period_months%TYPE;

666: g_user_service_table_dts service_table;
667: g_user_service_table_ymd service_table;
668:
669: total_service_years per_previous_jobs.period_years%TYPE;
670: total_service_months per_previous_jobs.period_months%TYPE;
671: total_service_days per_previous_jobs.period_days%TYPE;
672: service_type fnd_common_lookups.description%TYPE;
673:
674: temp_days number := 0 ;

Line 671: total_service_days per_previous_jobs.period_days%TYPE;

667: g_user_service_table_ymd service_table;
668:
669: total_service_years per_previous_jobs.period_years%TYPE;
670: total_service_months per_previous_jobs.period_months%TYPE;
671: total_service_days per_previous_jobs.period_days%TYPE;
672: service_type fnd_common_lookups.description%TYPE;
673:
674: temp_days number := 0 ;
675: temp_months number := 0 ;