APPS.HR_PL_UTILITY dependencies on FND_COMMON_LOOKUPS

Line 618: lookup_type_val fnd_common_lookups.lookup_type%TYPE;

614: RETURN number IS
615:
616:
617:
618: lookup_type_val fnd_common_lookups.lookup_type%TYPE;
619: lookup_descr_val1 fnd_common_lookups.description%TYPE;
620: lookup_descr_val2 fnd_common_lookups.description%TYPE;
621:
622: cursor csr_service_period_dts is

Line 619: lookup_descr_val1 fnd_common_lookups.description%TYPE;

615:
616:
617:
618: lookup_type_val fnd_common_lookups.lookup_type%TYPE;
619: lookup_descr_val1 fnd_common_lookups.description%TYPE;
620: lookup_descr_val2 fnd_common_lookups.description%TYPE;
621:
622: cursor csr_service_period_dts is
623: select ppj.start_date, ppj.end_date,

Line 620: lookup_descr_val2 fnd_common_lookups.description%TYPE;

616:
617:
618: lookup_type_val fnd_common_lookups.lookup_type%TYPE;
619: lookup_descr_val1 fnd_common_lookups.description%TYPE;
620: lookup_descr_val2 fnd_common_lookups.description%TYPE;
621:
622: cursor csr_service_period_dts is
623: select ppj.start_date, ppj.end_date,
624: ppj.period_years, ppj.period_months,

Line 672: service_type fnd_common_lookups.description%TYPE;

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 ;
676: temp_years number := 0 ;