APPS.PA_FUND_REVAL_UTIL dependencies on PA_PROJECT_TYPES_ALL

Line 40: PA_PROJECT_TYPES_ALL

36: BEGIN
37: SELECT 'Y' INTO l_flag
38: FROM DUAL
39: WHERE exists (SELECT NULL FROM
40: PA_PROJECT_TYPES_ALL
41: WHERE org_id = p_org_id
42: /* WHERE NVL(org_id,-99) = NVL(p_org_id,-99) Bug 5900353*/
43: AND NVL(include_gains_losses_flag,'N') ='Y');
44:

Line 130: FROM PA_PROJECT_TYPES_ALL pt

126: BEGIN
127: BEGIN
128: SELECT NVL(pt.include_gains_losses_flag,'N')
129: INTO l_flag
130: FROM PA_PROJECT_TYPES_ALL pt
131: WHERE pt.org_id = p_org_id
132: /* WHERE NVL(pt.org_id,-99) = NVL(p_org_id,-99)Bug 5900353 */
133: AND pt.project_type = p_project_type;
134: