APPS.PA_PROGRESS_UTILS dependencies on DUAL

Line 791: from dual;

787: l_return_ppc_id NUMBER;
788: BEGIN
789: select PA_PERCENT_COMPLETES_S.nextval
790: into l_return_ppc_id
791: from dual;
792:
793: RETURN l_return_ppc_id;
794: END get_next_ppc_id;
795:

Line 811: -- FROM DUAL

807:
808: -- CURSOR as_of_dates_csr
809: -- IS
810: -- SELECT 'Y'
811: -- FROM DUAL
812: -- WHERE trunc(p_as_of_date) IN
813: -- (SELECT trunc(as_of_date)
814: -- FROM PA_PROG_AS_OF_DATES
815: -- WHERE project_id = p_project_id

Line 827: SELECT trunc(p_as_of_date) FROM DUAL

823:
824: /* -- FPM Dev CR 3
825: CURSOR as_of_dates_csr
826: IS
827: SELECT trunc(p_as_of_date) FROM DUAL
828: MINUS
829: SELECT
830: trunc(as_of_date)
831: FROM PA_PROG_AS_OF_DATES

Line 841: SELECT trunc(p_as_of_date) FROM DUAL

837:
838: -- FPM Dev CR 3 : Added two new cursors. Now we are not relying on pa_prog_as_of_dates view.
839: CURSOR as_of_dates_task_dlvr_csr
840: IS
841: SELECT trunc(p_as_of_date) FROM DUAL
842: MINUS
843: SELECT PA_PROGRESS_UTILS.AS_OF_DATE(ppe.project_id, ppe.proj_element_id, ppp.progress_cycle_id, ppe.object_type, 'WORKPLAN', p_proj_element_id/* Amit : Modified for IB4 Progress CR. */) as_of_date
844: from pa_project_statuses po, pa_proj_progress_attr ppp, pa_proj_elements ppe -- Bug 4535784 Changed from pa_resource_types to pa_project_statuses
845: where ppe.project_id = ppp.project_id(+)

Line 859: SELECT trunc(p_as_of_date) FROM DUAL

855: /* Modified for IB4 Progress CR. */
856:
857: CURSOR as_of_dates_assgn_csr
858: IS
859: SELECT trunc(p_as_of_date) FROM DUAL
860: MINUS
861: SELECT PA_PROGRESS_UTILS.AS_OF_DATE(ppe.project_id, ppe.resource_list_member_id, ppp.progress_cycle_id, 'PA_ASSIGNMENTS', 'WORKPLAN', p_proj_element_id/* Amit : Modified for IB4 Progress CR. */) as_of_date
862: from pa_resource_types po, pa_proj_progress_attr ppp, PA_TASK_ASSIGNMENTS_V ppe
863: where ppe.project_id = ppp.project_id(+)

Line 5610: FROM DUAL

5606:
5607: BEGIN
5608: SELECT 'N'
5609: INTO l_return_value
5610: FROM DUAL
5611: WHERE EXISTS ( SELECT '1'
5612: FROM pa_progress_rollup ppr
5613: WHERE ppr.project_id = p_project_id
5614: AND object_type in ('PA_ASSIGNMENTS','PA_DELIVERABLES')

Line 5630: FROM DUAL

5626: BEGIN
5627:
5628: SELECT 'N'
5629: INTO l_return_value
5630: FROM DUAL
5631: WHERE EXISTS ( SELECT '1'
5632: FROM pa_percent_completes
5633: WHERE project_id = p_project_id
5634: AND structure_type = 'WORKPLAN'

Line 10340: -- Put the input parameters in individual tables for insert.

10336: l_num_blocks := 1.25 * (l_num_of_asgmts * 75) / l_db_block_size;
10337:
10338: IF l_num_of_asgmts > 0 THEN
10339:
10340: -- Put the input parameters in individual tables for insert.
10341: l_res_asgmt_id_tbl.extend(l_num_of_asgmts);
10342: l_new_rlm_id_tbl.extend(l_num_of_asgmts);
10343: l_override_cur_tbl.extend(l_num_of_asgmts);
10344: l_new_project_role_id_tbl.extend(l_num_of_asgmts);

Line 13319: FROM dual

13315: MINUS
13316: SELECT to_number(p_project_id) project_id,
13317: to_date(NULL) as_of_date,
13318: TO_CHAR(p_object_type) object_type
13319: FROM dual
13320: )
13321: WHERE ROWNUM = 1;
13322:
13323: BEGIN