APPS.HR_PL_UTILITY dependencies on HR_LOOKUPS

Line 647: from hr_lookups -- Replaced with hr_lookups

643: AND ppj.end_date IS NULL ;
644:
645: cursor csr_type_of_service is
646: select description
647: from hr_lookups -- Replaced with hr_lookups
648: where lookup_type = lookup_type_val
649: and lookup_code = P_TYPE_OF_SERVICE
650: and description in (lookup_descr_val1, lookup_descr_val2);
651:

Line 891: from hr_lookups

887: FUNCTION CHECK_CONTRIBUTION_TYPE(P_ENTRY_VALUE VARCHAR2) return NUMBER is
888: l_out number:=0;
889: cursor csr_lookup_code is
890: select lookup_code
891: from hr_lookups
892: where LOOKUP_TYPE='PL_CONTRIBUTION_TYPE'
893: and lookup_code=P_ENTRY_VALUE;
894: l_value hr_lookups.lookup_code%TYPE;
895: begin

Line 894: l_value hr_lookups.lookup_code%TYPE;

890: select lookup_code
891: from hr_lookups
892: where LOOKUP_TYPE='PL_CONTRIBUTION_TYPE'
893: and lookup_code=P_ENTRY_VALUE;
894: l_value hr_lookups.lookup_code%TYPE;
895: begin
896: l_value := NULL;
897: open csr_lookup_code;
898: fetch csr_lookup_code into l_value;