DBA Data[Home] [Help]

APPS.PAY_PAYGBP45_A4_PKG dependencies on HR_GENERAL

Line 109: C_TITLE := substr(HR_GENERAL.DECODE_LOOKUP('TITLE',TITLE),1,34);

105: ,W1_M1_INDICATOR IN VARCHAR2
106: ,SEX VARCHAR2
107: ,DATE_OF_BIRTH DATE) RETURN VARCHAR2 IS
108: BEGIN
109: C_TITLE := substr(HR_GENERAL.DECODE_LOOKUP('TITLE',TITLE),1,34);
110:
111: C_PER_ADDRESS_LINE1 := substr(ADDRESS_LINE1,1,34);
112: /*C_PER_ADDRESS_LINE2 := SUBSTR(RTRIM(ADDRESS_LINE2) || RTRIM(', ' || ADDRESS_LINE3
113: ,', ')