APPS.PATC dependencies on DUAL

Line 387: FROM dual

383: dummy NUMBER;
384: BEGIN
385: SELECT count(1)
386: INTO dummy
387: FROM dual
388: WHERE NOT EXISTS
389: ( SELECT 1
390: FROM pa_expend_typ_sys_links etsl
391: , pa_expenditure_types et

Line 463: FROM dual

459: dummy NUMBER;
460: BEGIN
461: SELECT count(1)
462: INTO dummy
463: FROM dual
464: WHERE EXISTS
465: ( SELECT 1
466: FROM pa_transaction_controls
467: WHERE project_id = X_project_id

Line 746: FROM dual

742: dummy :=0;
743:
744: SELECT count(1)
745: INTO dummy
746: FROM dual
747: WHERE EXISTS
748: ( SELECT 1
749: FROM pa_expend_typ_sys_links etsl
750: , pa_expenditure_types et

Line 1135: select to_number(SUBSTR(USERENV('CLIENT_INFO'),1,10)) into l_prvdr_org_id from dual; */

1131:
1132: If p_sys_link_function = 'VI' and X_calling_module not in ('APXRICAD','POXPOEPO') Then /*Added for bug 3608942,6118060 , 12660934 */
1133: /* start for bug#3088249 */
1134: /* Modified the following select statement for bug 3620355
1135: select to_number(SUBSTR(USERENV('CLIENT_INFO'),1,10)) into l_prvdr_org_id from dual; */
1136: /* Begin Bug 5214766
1137: We no longer use client info to get the operating_unit in r12 due to MOAC being introduced.
1138: We using pa_moac_utils.get_current_org_id;
1139: select to_number(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' '

Line 1140: ,NULL ,SUBSTRB(USERENV('CLIENT_INFO'),1,10))) into l_prvdr_org_id from dual;

1136: /* Begin Bug 5214766
1137: We no longer use client info to get the operating_unit in r12 due to MOAC being introduced.
1138: We using pa_moac_utils.get_current_org_id;
1139: select to_number(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' '
1140: ,NULL ,SUBSTRB(USERENV('CLIENT_INFO'),1,10))) into l_prvdr_org_id from dual;
1141: */
1142: l_prvdr_org_id := pa_moac_utils.get_current_org_id;
1143: /* End bug 5214766*/ /*14621140 - Added a closing brace here other wise get pa date was not getting called*/
1144: