DBA Data[Home] [Help]

APPS.PQH_SS_PRINT dependencies on HR_GENERAL

Line 437: SELECT hr_general.decode_lookup('PQH_TENURE_STATUS',p_lookup_code) into l_meaning

433:
434: l_meaning hr_lookups.meaning%type :=null;
435: BEGIN
436:
437: SELECT hr_general.decode_lookup('PQH_TENURE_STATUS',p_lookup_code) into l_meaning
438: FROM DUAL;
439:
440: return l_meaning;
441:

Line 828: return (hr_general.decode_lookup ('BARGAINING_UNIT_CODE',p_bargaining_unit_code));

824: FUNCTION decode_bargaining_unit_code (p_bargaining_unit_code IN VARCHAR2)
825: RETURN VARCHAR2 IS
826: --
827: BEGIN
828: return (hr_general.decode_lookup ('BARGAINING_UNIT_CODE',p_bargaining_unit_code));
829: END decode_bargaining_unit_code;
830: --
831: FUNCTION decode_collective_agreement(p_collective_agreement_id IN NUMBER)
832: RETURN VARCHAR2 IS