3504: WHERE organization_id = p_organization_id
3505: AND parent_lpn_id = p_lpn_id
3506: AND wlpnc.inventory_item_id = p_item_id
3507: AND EXISTS(SELECT 1
3508: FROM cst_cost_group_accounts
3509: WHERE organization_id = p_organization_id
3510: AND cost_group_id = wlpnc.cost_group_id);
3511: EXCEPTION
3512: WHEN OTHERS THEN
3519: WHERE organization_id = p_organization_id
3520: AND parent_lpn_id = p_lpn_id
3521: AND wlpnc.inventory_item_id = p_item_id
3522: AND NOT EXISTS(SELECT 1
3523: FROM cst_cost_group_accounts
3524: WHERE organization_id = p_organization_id
3525: AND cost_group_id = wlpnc.cost_group_id);
3526: END IF;
3527: END IF;