APPS.CSI_WIP_TRXS_PKG dependencies on DUAL

Line 3970: FROM sys.dual

3966: -- also check if the txn is in csi_transaction
3967: BEGIN
3968: SELECT 'Y'
3969: INTO l_csi_txn_found
3970: FROM sys.dual
3971: WHERE exists (
3972: SELECT 'X' FROM csi_transactions
3973: WHERE inv_material_transaction_id = compl_rec.transaction_id);
3974: l_completion_found := TRUE;

Line 3996: FROM sys.dual

3992: -- also check if the txn is in csi_transaction
3993: BEGIN
3994: SELECT 'Y'
3995: INTO l_csi_txn_found
3996: FROM sys.dual
3997: WHERE exists (
3998: SELECT 'X' FROM csi_transactions
3999: WHERE inv_material_transaction_id = issue_rec.transaction_id);
4000: l_issues_found := TRUE;

Line 6040: FROM sys.dual

6036:
6037: BEGIN
6038: SELECT 'Y'
6039: INTO l_comp_is_assy
6040: FROM sys.dual
6041: WHERE exists (
6042: SELECT 'X'
6043: FROM csi_item_instances
6044: WHERE last_vld_organization_id = p_mmt_rec.organization_id