APPS.PA_CHECK_COMMITMENTS dependencies on DUAL

Line 19: FROM DUAL

15: WHERE common_project_id = p_ProjectID ;
16:
17: Cursor is_cash_basis_enabled_cur IS /* Bug#4905546 */
18: SELECT 'Y' /* to find whether cash basis accounting is enabled or not */
19: FROM DUAL
20: WHERE EXISTS (
21: SELECT NVL(GLSLA.SLA_LEDGER_CASH_BASIS_FLAG,'N')
22: FROM GL_LEDGERS GLSLA,
23: PA_IMPLEMENTATIONS_ALL IMP,

Line 78: FROM DUAL

74: IF (PA_PROJ_ACCUM_MAIN.G_GMS_Enabled = 'Y')
75: THEN
76: BEGIN
77: SELECT 'Y' INTO v_tmp
78: FROM DUAL
79: WHERE EXISTS (
80: SELECT enc1.encumbrance_item_id
81: FROM gms_encumbrance_items_all Enc1,
82: pa_tasks T

Line 126: FROM DUAL

122: Begin -- Second Block
123:
124: SELECT 'Y'
125: INTO v_tmp
126: FROM DUAL
127: WHERE EXISTS (
128: SELECT '1'
129: FROM
130: PO_REQ_DISTRIBUTIONS_ALL RD

Line 196: FROM DUAL

192: IF is_cash_basis_enabled_flag = 'Y' Then /* Bug#4905546 */
193:
194: SELECT 'Y' /* When cash basis accounting is enabled */
195: INTO v_tmp
196: FROM DUAL
197: WHERE EXISTS (
198: SELECT '1'
199: FROM
200: pa_proj_ap_inv_distributions apd

Line 218: FROM DUAL

214: ELSE
215:
216: SELECT 'Y' /* When cash basis accounting is not enabled */
217: INTO v_tmp
218: FROM DUAL
219: WHERE EXISTS (
220: SELECT '1'
221: FROM
222: AP_INVOICES_ALL I /* Changed for the bug #1530740 */

Line 264: FROM DUAL

260: Begin -- Fourth Block
261:
262: SELECT 'Y'
263: INTO v_tmp
264: FROM DUAL
265: WHERE EXISTS
266: (
267: SELECT /*+ leading(pod) */ '1' --bug 6872563 - skkoppul : Added hint
268: FROM

Line 336: FROM DUAL

332: Begin -- Fifth Block
333:
334: SELECT 'Y'
335: INTO v_tmp
336: FROM DUAL
337: WHERE EXISTS
338: (
339: SELECT '1'
340: FROM PA_COMMITMENT_TXNS CMT

Line 482: FROM DUAL

478: Begin -- Sixth Block
479:
480: SELECT 'Y'
481: INTO v_tmp
482: FROM DUAL
483: WHERE EXISTS
484: (
485: SELECT '1'
486: FROM PA_COMMITMENT_TXNS CMT

Line 574: FROM DUAL

570: Begin -- Seventh Block
571:
572: SELECT 'Y'
573: INTO v_tmp
574: FROM DUAL
575: WHERE EXISTS
576: (
577: SELECT '1'
578: FROM PA_COMMITMENT_TXNS CMT

Line 670: FROM DUAL

666: Begin -- Eighth Block
667:
668: SELECT 'Y'
669: INTO v_tmp
670: FROM DUAL
671: WHERE EXISTS
672: (
673: SELECT '1'
674: FROM PA_COMMITMENT_TXNS CMT

Line 749: FROM DUAL

745: Begin -- Ninth Block
746:
747: SELECT 'Y'
748: INTO v_tmp
749: FROM DUAL
750: WHERE EXISTS (
751: SELECT '1'
752: FROM
753: CST_PROJMFG_CMT_VIEW CST

Line 787: FROM DUAL

783: Begin -- Tenth Block
784: /* Commented and Modified for bug 4360855 as below as suggested by PJM Team.
785: SELECT 'Y'
786: INTO v_tmp
787: FROM DUAL
788: WHERE EXISTS (
789: SELECT '1'
790: FROM
791: PJM_REQ_COMMITMENTS_V PJREQ

Line 808: FROM dual where exists (select 1 from pjm_org_parameters

804: );*/
805: /* Bug 5517898 */
806: SELECT 1 -- common project
807: INTO tmp
808: FROM dual where exists (select 1 from pjm_org_parameters
809: WHERE common_project_id = p_ProjectID);
810: /* Bug 5517898 */
811:
812: FOR c_rec in c loop

Line 816: FROM DUAL

812: FOR c_rec in c loop
813: Begin
814: SELECT 'Y'
815: INTO v_tmp
816: FROM DUAL
817: WHERE EXISTS (
818: SELECT REQUISITION_HEADER_ID,
819: LINE_NUM,
820: DISTRIBUTION_ID

Line 886: FROM DUAL

882: Begin
883:
884: SELECT 'Y'
885: INTO v_tmp
886: FROM DUAL
887: WHERE EXISTS (
888: SELECT REQUISITION_HEADER_ID,
889: LINE_NUM,
890: DISTRIBUTION_ID

Line 956: FROM DUAL

952: Begin -- Eleventh Block
953:
954: SELECT 'Y'
955: INTO v_tmp
956: FROM DUAL
957: WHERE EXISTS
958: (
959: SELECT '1'
960: FROM PA_COMMITMENT_TXNS CMT

Line 1017: FROM DUAL

1013: Begin -- Twelvth Block
1014: /* Commented and Modified for bug 4360855 as below as suggested by PJM Team.
1015: SELECT 'Y'
1016: INTO v_tmp
1017: FROM DUAL
1018: WHERE EXISTS
1019: (
1020: SELECT '1'
1021: FROM

Line 1039: FROM dual where exists (select 1 from pjm_org_parameters

1035: );*/
1036: /* Bug 5517898 */
1037: SELECT 1 -- common project
1038: INTO tmp
1039: FROM dual where exists (select 1 from pjm_org_parameters
1040: WHERE common_project_id = p_ProjectID);
1041: /* Bug 5517898 */
1042: FOR c_rec in c loop
1043: Begin

Line 1046: FROM DUAL

1042: FOR c_rec in c loop
1043: Begin
1044: SELECT 'Y'
1045: INTO v_tmp
1046: FROM DUAL
1047: WHERE EXISTS (
1048: SELECT PO_HEADER_ID,
1049: LINE_NUM,
1050: PO_DISTRIBUTION_ID

Line 1116: FROM DUAL

1112: Begin
1113:
1114: SELECT 'Y'
1115: INTO v_tmp
1116: FROM DUAL
1117: WHERE EXISTS (
1118: SELECT PO_HEADER_ID,
1119: LINE_NUM,
1120: PO_DISTRIBUTION_ID

Line 1185: FROM DUAL

1181: Begin -- Thirteenth Block
1182:
1183: SELECT 'Y'
1184: INTO v_tmp
1185: FROM DUAL
1186: WHERE EXISTS
1187: (
1188: SELECT '1'
1189: FROM PA_COMMITMENT_TXNS CMT