APPS.CSI_WIP_TRXS_PKG dependencies on DUAL

Line 3835: FROM sys.dual

3831: -- also check if the txn is in csi_transaction
3832: BEGIN
3833: SELECT 'Y'
3834: INTO l_csi_txn_found
3835: FROM sys.dual
3836: WHERE exists (
3837: SELECT 'X' FROM csi_transactions
3838: WHERE inv_material_transaction_id = compl_rec.transaction_id);
3839: l_completion_found := TRUE;

Line 3861: FROM sys.dual

3857: -- also check if the txn is in csi_transaction
3858: BEGIN
3859: SELECT 'Y'
3860: INTO l_csi_txn_found
3861: FROM sys.dual
3862: WHERE exists (
3863: SELECT 'X' FROM csi_transactions
3864: WHERE inv_material_transaction_id = issue_rec.transaction_id);
3865: l_issues_found := TRUE;

Line 5834: FROM sys.dual

5830:
5831: BEGIN
5832: SELECT 'Y'
5833: INTO l_comp_is_assy
5834: FROM sys.dual
5835: WHERE exists (
5836: SELECT 'X'
5837: FROM csi_item_instances
5838: WHERE last_vld_organization_id = p_mmt_rec.organization_id