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 1723: FROM PA_REVENUE_CATEGORIES_V RC

1719: FROM (
1720: SELECT
1721: REVENUE_CATEGORY_CODE
1722: ,REVENUE_CATEGORY_M description
1723: FROM PA_REVENUE_CATEGORIES_V RC
1724: 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))
1725: ) tmp
1726: WHERE
1727: tmp.revenue_category_code = l_revenue_category_code;