APPS.PA_PROJECT_STRUCTURE_PVT1 dependencies on DUAL

Line 336: select PA_TASKS_S.NEXTVAL into l_proj_element_id from sys.dual;

332: RAISE FND_API.G_EXC_ERROR;
333: END IF;
334:
335: --Insert into pa_proj_elements
336: select PA_TASKS_S.NEXTVAL into l_proj_element_id from sys.dual;
337:
338: PA_PROJ_ELEMENTS_PKG.insert_row(
339: X_ROW_ID => l_rowid
340: ,X_PROJ_ELEMENT_ID => l_proj_element_id

Line 669: FROM sys.dual;

665: where proj_element_id = p_structure_id;
666:
667: CURSOR cur_elem_ver_seq IS
668: SELECT pa_proj_element_versions_s.nextval
669: FROM sys.dual;
670:
671: BEGIN
672: IF (p_debug_mode = 'Y') THEN
673: pa_debug.debug('PA_PROJECT_STRUCTURE_PVT1.CREATE_STRUCTURE_VERSION begin');

Line 3274: FROM sys.dual;

3270:
3271: l_rowid VARCHAR2(255);
3272: CURSOR cur_elem_ver_seq IS
3273: SELECT pa_proj_element_versions_s.nextval
3274: FROM sys.dual;
3275:
3276: l_last_pub_str_ver_id NUMBER; --Bug No. 3450684 Smukka 01/03/2004
3277: l_chk_deliverable VARCHAR2(80); --Summuka For checking deliverables
3278:

Line 8054: select PA_TASKS_S.NEXTVAL into l_task_id from sys.dual;

8050: -- If (l_is_workplan = 'Y') AND (l_is_billing = 'N') AND (l_is_costing = 'N') THEN
8051: l_task_id := NULL;
8052: IF (l_structure_type = 'WORKPLAN') THEN
8053: --get new id
8054: select PA_TASKS_S.NEXTVAL into l_task_id from sys.dual;
8055: ELSE
8056: --id exists in pa_tasks. Need to find matching id by using task_number
8057: OPEN l_get_pa_tasks_csr(p_dest_project_id, l_tasks_rec.PA_TASK_NUMBER);
8058: FETCH l_get_pa_tasks_csr into l_task_id;

Line 9197: select 'Y' from dual

9193: and element_version_id = p_structure_version_id;
9194:
9195: /* Bug 2683138 */
9196: /* CURSOR get_start_wf IS
9197: select 'Y' from dual
9198: where exists (
9199: select 1 from pa_product_installation_v
9200: where product_short_code = 'PJT' AND INSTALLED_FLAG = 'Y'); */
9201:

Line 9203: select 'Y' from dual;

9199: select 1 from pa_product_installation_v
9200: where product_short_code = 'PJT' AND INSTALLED_FLAG = 'Y'); */
9201:
9202: CURSOR get_start_wf IS
9203: select 'Y' from dual;
9204:
9205: CURSOR get_wf_info(c_status_code VARCHAR2) IS
9206: select enable_wf_flag, workflow_item_type,
9207: workflow_process, wf_success_status_code,

Line 9502: select 'Y' from dual

9498: l_msg_data VARCHAR2(250);
9499:
9500: /* Bug 2683138 */
9501: /* CURSOR get_start_wf IS
9502: select 'Y' from dual
9503: where exists (
9504: select 1 from pa_product_installation_v
9505: where product_short_code = 'PJT' AND INSTALLED_FLAG = 'Y'); */
9506:

Line 9508: select 'Y' from dual;

9504: select 1 from pa_product_installation_v
9505: where product_short_code = 'PJT' AND INSTALLED_FLAG = 'Y'); */
9506:
9507: CURSOR get_start_wf IS
9508: select 'Y' from dual;
9509:
9510: CURSOR get_wf_info(c_status_code VARCHAR2) IS
9511: select enable_wf_flag, workflow_item_type,
9512: workflow_process, wf_success_status_code,

Line 13369: FROM sys.dual;

13365: l_login_id number;
13366:
13367: CURSOR cur_elem_ver_seq IS
13368: SELECT pa_proj_element_versions_s.nextval
13369: FROM sys.dual;
13370:
13371: l_wp_struc VARCHAR2(1);
13372: l_fin_struc VARCHAR2(1);
13373: