660: RETURN number IS
661:
662:
663:
664: lookup_type_val fnd_common_lookups.lookup_type%TYPE;
665: lookup_descr_val1 fnd_common_lookups.description%TYPE;
666: lookup_descr_val2 fnd_common_lookups.description%TYPE;
667:
668: cursor csr_service_period_dts is
661:
662:
663:
664: lookup_type_val fnd_common_lookups.lookup_type%TYPE;
665: lookup_descr_val1 fnd_common_lookups.description%TYPE;
666: lookup_descr_val2 fnd_common_lookups.description%TYPE;
667:
668: cursor csr_service_period_dts is
669: select ppj.start_date, ppj.end_date,
662:
663:
664: lookup_type_val fnd_common_lookups.lookup_type%TYPE;
665: lookup_descr_val1 fnd_common_lookups.description%TYPE;
666: lookup_descr_val2 fnd_common_lookups.description%TYPE;
667:
668: cursor csr_service_period_dts is
669: select ppj.start_date, ppj.end_date,
670: ppj.period_years, ppj.period_months,
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 ;
722: temp_years number := 0 ;