DBA Data[Home] [Help]

APPS.PA_PAXPRFRP_XMLP_PKG dependencies on PA_PROJECT_TYPES

Line 102: PA_PROJECT_TYPES

98: SELECT
99: PROJECT_TYPE
100: INTO V_PROJECT_TYPE
101: FROM
102: PA_PROJECT_TYPES
103: WHERE PROJECT_TYPE_ID = P_PROJECT_TYPE_ID
104: AND DIRECT_FLAG = 'Y'
105: AND SYSDATE between START_DATE_ACTIVE
106: AND NVL(END_DATE_ACTIVE