APPS.PA_CREATE_RESOURCE dependencies on PA_REVENUE_CATEGORIES_V

Line 121: FROM PA_REVENUE_CATEGORIES_V RC

117: FROM (
118: SELECT
119: REVENUE_CATEGORY_CODE
120: ,REVENUE_CATEGORY_M description
121: FROM PA_REVENUE_CATEGORIES_V RC
122: WHERE DECODE(PA_GET_RESOURCE.INCLUDE_INACTIVE_RESOURCES, 'Y', START_DATE_ACTIVE,TRUNC(SYSDATE)) BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE,TRUNC(SYSDATE))
123: ) tmp
124: WHERE
125: tmp.revenue_category_code = p_resource_group;

Line 2071: FROM PA_REVENUE_CATEGORIES_V RC

2067: FROM (
2068: SELECT
2069: REVENUE_CATEGORY_CODE
2070: ,REVENUE_CATEGORY_M description
2071: FROM PA_REVENUE_CATEGORIES_V RC
2072: WHERE DECODE(PA_GET_RESOURCE.INCLUDE_INACTIVE_RESOURCES, 'Y', START_DATE_ACTIVE,TRUNC(SYSDATE)) BETWEEN START_DATE_ACTIVE AND NVL(END_DATE_ACTIVE,TRUNC(SYSDATE))
2073: ) tmp
2074: WHERE
2075: tmp.revenue_category_code = l_revenue_category_code;