DBA Data[Home] [Help]

APPS.PA_PROJECT_CORE1 dependencies on DUAL

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

1122:
1123: -- copy project
1124: declare
1125: cursor c1 is
1126: select pa_projects_s.nextval from sys.dual;
1127:
1128: --bug 2434241
1129: cursor c2 is
1130: select retn_accounting_flag from pa_implementations;

Line 1136: SELECT 'YES' FROM DUAL

1132: --bug 2434241
1133:
1134: -- Bug 2900258
1135: Cursor c3 is
1136: SELECT 'YES' FROM DUAL
1137: WHERE EXISTS ( SELECT 1 FROM FND_DESCRIPTIVE_FLEXS
1138: WHERE APPLICATION_ID=275
1139: AND APPLICATION_TABLE_NAME='PA_PROJECTS_ALL'
1140: AND DESCRIPTIVE_FLEXFIELD_NAME = 'PA_PROJECTS_DESC_FLEX'

Line 2501: FROM DUAL

2497: /*Code addition for bug 2719670 ends*/
2498:
2499: cursor c_cust_created_org_csr(c_project_id IN NUMBER, c_project_party_id IN NUMBER) is
2500: SELECT 'Y'
2501: FROM DUAL
2502: WHERE EXISTS
2503: (SELECT customer_id
2504: FROM pa_project_customers
2505: WHERE project_id = c_project_id