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