DBA Data[Home] [Help]

APPS.PQH_PQHUSEPR_XMLP_PKG dependencies on HR_LOOKUPS

Line 75: HR_LOOKUPS

71: CURSOR ACADEMIC_RANK_CUR IS
72: SELECT
73: MEANING
74: FROM
75: HR_LOOKUPS
76: WHERE LOOKUP_TYPE = 'PQH_ACADEMIC_RANK'
77: AND LOOKUP_CODE = RANK_ID;
78: L_ACADEMIC_RANK VARCHAR2(40);
79: BEGIN

Line 96: HR_LOOKUPS

92: CURSOR TENURE_STATUS_CUR IS
93: SELECT
94: MEANING
95: FROM
96: HR_LOOKUPS
97: WHERE LOOKUP_TYPE = 'PQH_TENURE_STATUS'
98: AND LOOKUP_CODE = TENURE_STATUS_CD;
99: L_TENURE_STATUS VARCHAR2(40);
100: BEGIN