DBA Data[Home] [Help]

APPS.IGI_EXP_HOLDS dependencies on DUAL

Line 123: FROM SYS.DUAL

119: l_get_hold_reason.displayed_field, --'Exchange Protocol Hold',
120: 'S',
121: AP_HOLDS_S.NEXTVAL,
122: mo_global.get_current_org_id()
123: FROM SYS.DUAL
124: WHERE NOT EXISTS(SELECT 'x'
125: FROM ap_holds_all ah2
126: WHERE ah2.invoice_id = p_invoice_id
127: AND ah2.hold_lookup_code = 'AWAIT EXP APP'