DBA Data[Home] [Help]

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