APPS.CSI_ORDER_SHIP_PUB dependencies on DUAL

Line 5363: FROM dual;

5359: /* get the profile value for CSI default install date */
5360: BEGIN
5361: SELECT nvl(fnd_profile.value('CSI_DEF_INST_DATE'),'N')
5362: INTO l_default_install_date
5363: FROM dual;
5364: EXCEPTION
5365: WHEN OTHERS THEN
5366: NULL;
5367: END;

Line 6252: FROM sys.dual

6248: l_owner_acct_rec := null;
6249:
6250: BEGIN
6251: SELECT 'Y' INTO l_cia_found
6252: FROM sys.dual
6253: WHERE exists (
6254: SELECT '1' FROM csi_i_assets
6255: WHERE instance_id = l_upd_instance_rec.instance_id
6256: AND sysdate between nvl(active_start_date, sysdate-1) and nvl(active_end_date, sysdate+1));

Line 7871: FROM sys.dual;

7867:
7868: BEGIN
7869: SELECT csi_t_party_details_s.nextval
7870: INTO l_txn_party_detail_id
7871: FROM sys.dual;
7872: EXCEPTION
7873: WHEN others THEN
7874: debug('Sequence csi_t_party_details_s is missing');
7875: raise fnd_api.g_exc_error;