DBA Data[Home] [Help]

APPS.XDP_ORDER dependencies on HZ_CUST_SITE_USES_ALL

Line 1158: SELECT 1 INTO lv_site_use_id from HZ_CUST_SITE_USES_ALL SITES

1154: /**** Validate Site Use Id ****/
1155:
1156: IF p_service_order_line_list(lv_index).site_use_id IS NOT NULL THEN
1157: BEGIN
1158: SELECT 1 INTO lv_site_use_id from HZ_CUST_SITE_USES_ALL SITES
1159: WHERE SITES.SITE_USE_ID = p_service_order_line_list(lv_index).site_use_id;
1160:
1161: IF((FND_LOG.LEVEL_EXCEPTION >= FND_LOG.G_CURRENT_RUNTIME_LEVEL)) THEN
1162: IF (FND_LOG.TEST(FND_LOG.LEVEL_STATEMENT, 'xdp.plsql.XDP_ORDER.VALIDATE_ORDER_LINE')) THEN