DBA Data[Home] [Help]

APPS.INV_RCV_DIR_RCPT_APIS dependencies on CST_COST_GROUP_ACCOUNTS

Line 3508: FROM cst_cost_group_accounts

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

Line 3523: FROM cst_cost_group_accounts

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;