APPS.HR_PL_UTILITY dependencies on PER_PREVIOUS_JOBS

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

711:
712: g_user_service_table_dts service_table;
713: g_user_service_table_ymd service_table;
714:
715: total_service_years per_previous_jobs.period_years%TYPE;
716: total_service_months per_previous_jobs.period_months%TYPE;
717: total_service_days per_previous_jobs.period_days%TYPE;
718: service_type fnd_common_lookups.description%TYPE;
719:

Line 716: total_service_months per_previous_jobs.period_months%TYPE;

712: g_user_service_table_dts service_table;
713: g_user_service_table_ymd service_table;
714:
715: total_service_years per_previous_jobs.period_years%TYPE;
716: total_service_months per_previous_jobs.period_months%TYPE;
717: total_service_days per_previous_jobs.period_days%TYPE;
718: service_type fnd_common_lookups.description%TYPE;
719:
720: temp_days number := 0 ;

Line 717: total_service_days per_previous_jobs.period_days%TYPE;

713: g_user_service_table_ymd service_table;
714:
715: total_service_years per_previous_jobs.period_years%TYPE;
716: total_service_months per_previous_jobs.period_months%TYPE;
717: total_service_days per_previous_jobs.period_days%TYPE;
718: service_type fnd_common_lookups.description%TYPE;
719:
720: temp_days number := 0 ;
721: temp_months number := 0 ;