APPS.HR_PL_UTILITY dependencies on HR_LOOKUPS

Line 693: from hr_lookups -- Replaced with hr_lookups

689: AND ppj.end_date IS NULL ;
690:
691: cursor csr_type_of_service is
692: select description
693: from hr_lookups -- Replaced with hr_lookups
694: where lookup_type = lookup_type_val
695: and lookup_code = P_TYPE_OF_SERVICE
696: and description in (lookup_descr_val1, lookup_descr_val2);
697:

Line 937: from hr_lookups

933: FUNCTION CHECK_CONTRIBUTION_TYPE(P_ENTRY_VALUE VARCHAR2) return NUMBER is
934: l_out number:=0;
935: cursor csr_lookup_code is
936: select lookup_code
937: from hr_lookups
938: where LOOKUP_TYPE='PL_CONTRIBUTION_TYPE'
939: and lookup_code=P_ENTRY_VALUE;
940: l_value hr_lookups.lookup_code%TYPE;
941: begin

Line 940: l_value hr_lookups.lookup_code%TYPE;

936: select lookup_code
937: from hr_lookups
938: where LOOKUP_TYPE='PL_CONTRIBUTION_TYPE'
939: and lookup_code=P_ENTRY_VALUE;
940: l_value hr_lookups.lookup_code%TYPE;
941: begin
942: l_value := NULL;
943: open csr_lookup_code;
944: fetch csr_lookup_code into l_value;