DBA Data[Home] [Help]

APPS.INV_RCV_DIR_RCPT_APIS dependencies on CST_COST_GROUP_ACCOUNTS

Line 3612: FROM cst_cost_group_accounts

3608: WHERE organization_id = p_organization_id
3609: AND parent_lpn_id = p_lpn_id
3610: AND wlpnc.inventory_item_id = p_item_id
3611: AND EXISTS(SELECT 1
3612: FROM cst_cost_group_accounts
3613: WHERE organization_id = p_organization_id
3614: AND cost_group_id = wlpnc.cost_group_id);
3615: EXCEPTION
3616: WHEN OTHERS THEN

Line 3627: FROM cst_cost_group_accounts

3623: WHERE organization_id = p_organization_id
3624: AND parent_lpn_id = p_lpn_id
3625: AND wlpnc.inventory_item_id = p_item_id
3626: AND NOT EXISTS(SELECT 1
3627: FROM cst_cost_group_accounts
3628: WHERE organization_id = p_organization_id
3629: AND cost_group_id = wlpnc.cost_group_id);
3630: END IF;
3631: END IF;