APPS.PATC dependencies on DUAL

Line 354: FROM dual

350: dummy NUMBER;
351: BEGIN
352: SELECT count(1)
353: INTO dummy
354: FROM dual
355: WHERE NOT EXISTS
356: ( SELECT 1
357: FROM pa_expend_typ_sys_links etsl
358: , pa_expenditure_types et

Line 430: FROM dual

426: dummy NUMBER;
427: BEGIN
428: SELECT count(1)
429: INTO dummy
430: FROM dual
431: WHERE EXISTS
432: ( SELECT 1
433: FROM pa_transaction_controls
434: WHERE project_id = X_project_id

Line 692: FROM dual

688: dummy :=0;
689:
690: SELECT count(1)
691: INTO dummy
692: FROM dual
693: WHERE EXISTS
694: ( SELECT 1
695: FROM pa_expend_typ_sys_links etsl
696: , pa_expenditure_types et

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

937:
938: If p_sys_link_function = 'VI' and X_calling_module <> 'APXRICAD' Then /*Added for bug 3608942,6118060*/
939: /* start for bug#3088249 */
940: /* Modified the following select statement for bug 3620355
941: select to_number(SUBSTR(USERENV('CLIENT_INFO'),1,10)) into l_prvdr_org_id from dual; */
942: /* Begin Bug 5214766
943: We no longer use client info to get the operating_unit in r12 due to MOAC being introduced.
944: We using pa_moac_utils.get_current_org_id;
945: select to_number(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' '

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

942: /* Begin Bug 5214766
943: We no longer use client info to get the operating_unit in r12 due to MOAC being introduced.
944: We using pa_moac_utils.get_current_org_id;
945: select to_number(DECODE(SUBSTRB(USERENV('CLIENT_INFO'),1,1),' '
946: ,NULL ,SUBSTRB(USERENV('CLIENT_INFO'),1,10))) into l_prvdr_org_id from dual;
947: */
948: l_prvdr_org_id := pa_moac_utils.get_current_org_id;
949: /* End bug 5214766
950: