APPS.CSI_ORDER_SHIP_PUB dependencies on DUAL

Line 5147: FROM dual;

5143: /* get the profile value for CSI default install date */
5144: BEGIN
5145: SELECT nvl(fnd_profile.value('CSI_DEF_INST_DATE'),'N')
5146: INTO l_default_install_date
5147: FROM dual;
5148: EXCEPTION
5149: WHEN OTHERS THEN
5150: NULL;
5151: END;

Line 5992: FROM sys.dual

5988: l_owner_acct_rec := null;
5989:
5990: BEGIN
5991: SELECT 'Y' INTO l_cia_found
5992: FROM sys.dual
5993: WHERE exists (
5994: SELECT '1' FROM csi_i_assets
5995: WHERE instance_id = l_upd_instance_rec.instance_id
5996: AND sysdate between nvl(active_start_date, sysdate-1) and nvl(active_end_date, sysdate+1));

Line 7552: FROM sys.dual;

7548:
7549: BEGIN
7550: SELECT csi_t_party_details_s.nextval
7551: INTO l_txn_party_detail_id
7552: FROM sys.dual;
7553: EXCEPTION
7554: WHEN others THEN
7555: debug('Sequence csi_t_party_details_s is missing');
7556: raise fnd_api.g_exc_error;