APPS.PQH_PQHUSRCP_XMLP_PKG dependencies on HR_LOOKUPS
Line 77: HR_LOOKUPS
73: CURSOR ACADEMIC_RANK_CUR IS
74: SELECT
75: MEANING
76: FROM 77: HR_LOOKUPS 78: WHERE LOOKUP_TYPE = 'PQH_ACADEMIC_RANK'
79: AND LOOKUP_CODE = RANK_ID;
80: L_ACADEMIC_RANK VARCHAR2(40);
81: BEGIN
Line 98: HR_LOOKUPS
94: CURSOR TENURE_STATUS_CUR IS
95: SELECT
96: MEANING
97: FROM 98: HR_LOOKUPS 99: WHERE LOOKUP_TYPE = 'PQH_TENURE_STATUS'
100: AND LOOKUP_CODE = TENURE_STATUS_CD;
101: L_TENURE_STATUS VARCHAR2(40);
102: BEGIN