DBA Data[Home] [Help]

APPS.PA_FUND_REVAL_UTIL dependencies on DUAL

Line 38: FROM DUAL

34: BEGIN
35: -- Check project type level
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*/

Line 59: FROM DUAL

55:
56: -- Check project level
57: BEGIN
58: SELECT 'Y' INTO l_flag
59: FROM DUAL
60: WHERE exists (SELECT NULL FROM
61: PA_PROJECTS_ALL
62: WHERE org_id = p_org_id
63: /* WHERE NVL(org_id,-99) = NVL(p_org_id,-99) Bug 5900353*/

Line 79: FROM DUAL

75:
76: -- Check events level
77: BEGIN
78: SELECT 'Y' INTO l_flag
79: FROM DUAL
80: WHERE exists (SELECT NULL FROM
81: PA_EVENTS evt, PA_PROJECTS_ALL pr,
82: PA_EVENT_TYPES evttyp
83: WHERE pr.org_id = p_org_id