APPS.PA_PRJ_PROGRESS_REPORTS_PKG dependencies on DUAL

Line 10: from dual

6: is
7: dummy number;
8: Begin
9: select 1 into dummy
10: from dual
11: where exists (select 1
12: from pa_lookups
13: where lookup_type = 'PA_XC_PROGRESS_STATUS'
14: and lookup_code = p_progress_code);

Line 106: from dual;

102:
103: IF p_create_item_key_flag = 'Y' THEN
104: SELECT pa_workflow_itemkey_s.nextval
105: INTO l_wf_item_key_new
106: from dual;
107: x_item_key := l_wf_item_key_new;
108: ELSE
109: l_wf_item_key_new := p_wf_item_key_new;
110: END IF;

Line 570: FROM dual;

566:
567: --Fetch the next sequence number for progres report
568: SELECT PA_PROJ_PROGRESS_REPORTS_S.NEXTVAL
569: INTO l_progress_report_id
570: FROM dual;
571:
572: INSERT INTO PA_PROJ_PROGRESS_REPORTS(
573: PROGRESS_REPORT_ID
574: ,RECORD_VERSION_NUMBER