DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE1 dependencies on DUAL

Line 1114: select pa_projects_s.nextval from sys.dual;

1110:
1111: -- copy project
1112: declare
1113: cursor c1 is
1114: select pa_projects_s.nextval from sys.dual;
1115:
1116: --bug 2434241
1117: cursor c2 is
1118: select retn_accounting_flag from pa_implementations;

Line 1124: SELECT 'YES' FROM DUAL

1120: --bug 2434241
1121:
1122: -- Bug 2900258
1123: Cursor c3 is
1124: SELECT 'YES' FROM DUAL
1125: WHERE EXISTS ( SELECT 1 FROM FND_DESCRIPTIVE_FLEXS
1126: WHERE APPLICATION_ID=275
1127: AND APPLICATION_TABLE_NAME='PA_PROJECTS_ALL'
1128: AND DESCRIPTIVE_FLEXFIELD_NAME = 'PA_PROJECTS_DESC_FLEX'

Line 2458: FROM DUAL

2454: /*Code addition for bug 2719670 ends*/
2455:
2456: cursor c_cust_created_org_csr(c_project_id IN NUMBER, c_project_party_id IN NUMBER) is
2457: SELECT 'Y'
2458: FROM DUAL
2459: WHERE EXISTS
2460: (SELECT customer_id
2461: FROM pa_project_customers
2462: WHERE project_id = c_project_id