APPS.PA_PROGRESS_UTILS dependencies on DUAL

Line 789: from dual;

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

Line 808: -- FROM DUAL

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

Line 824: SELECT trunc(p_as_of_date) FROM DUAL

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

Line 838: SELECT trunc(p_as_of_date) FROM DUAL

834:
835: -- FPM Dev CR 3 : Added two new cursors. Now we are not relying on pa_prog_as_of_dates view.
836: CURSOR as_of_dates_task_dlvr_csr
837: IS
838: SELECT trunc(p_as_of_date) FROM DUAL
839: MINUS
840: 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
841: 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
842: where ppe.project_id = ppp.project_id(+)

Line 856: SELECT trunc(p_as_of_date) FROM DUAL

852: /* Modified for IB4 Progress CR. */
853:
854: CURSOR as_of_dates_assgn_csr
855: IS
856: SELECT trunc(p_as_of_date) FROM DUAL
857: MINUS
858: 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
859: from pa_resource_types po, pa_proj_progress_attr ppp, PA_TASK_ASSIGNMENTS_V ppe
860: where ppe.project_id = ppp.project_id(+)

Line 5577: FROM DUAL

5573:
5574: BEGIN
5575: SELECT 'N'
5576: INTO l_return_value
5577: FROM DUAL
5578: WHERE EXISTS ( SELECT '1'
5579: FROM pa_progress_rollup ppr
5580: WHERE ppr.project_id = p_project_id
5581: AND object_type in ('PA_ASSIGNMENTS','PA_DELIVERABLES')

Line 5597: FROM DUAL

5593: BEGIN
5594:
5595: SELECT 'N'
5596: INTO l_return_value
5597: FROM DUAL
5598: WHERE EXISTS ( SELECT '1'
5599: FROM pa_percent_completes
5600: WHERE project_id = p_project_id
5601: AND structure_type = 'WORKPLAN'

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

10262: l_num_blocks := 1.25 * (l_num_of_asgmts * 75) / l_db_block_size;
10263:
10264: IF l_num_of_asgmts > 0 THEN
10265:
10266: -- Put the input parameters in individual tables for insert.
10267: l_res_asgmt_id_tbl.extend(l_num_of_asgmts);
10268: l_new_rlm_id_tbl.extend(l_num_of_asgmts);
10269: l_override_cur_tbl.extend(l_num_of_asgmts);
10270: l_new_project_role_id_tbl.extend(l_num_of_asgmts);

Line 13222: FROM dual

13218: MINUS
13219: SELECT to_number(p_project_id) project_id,
13220: to_date(NULL) as_of_date,
13221: TO_CHAR(p_object_type) object_type
13222: FROM dual
13223: )
13224: WHERE ROWNUM = 1;
13225:
13226: BEGIN