DBA Data[Home] [Help]

APPS.OE_CUST_MERGE dependencies on HZ_CUSTOMER_PROFILES

Line 8541: update HZ_CUSTOMER_PROFILES

8537: IF l_hold_entity_id.count > 0 THEN
8538:
8539: FORALL i IN l_hold_entity_id.first..l_hold_entity_id.last
8540:
8541: update HZ_CUSTOMER_PROFILES
8542: set credit_hold = 'Y'
8543: where SITE_USE_ID = to_number(l_hold_entity_id(i))
8544: and l_hold_release_id(i) IS NULL
8545: and l_released_flag(i) = 'N'

Line 8556: update HZ_CUSTOMER_PROFILES

8552: IF l_hold_entity_id1.count > 0 THEN
8553:
8554: FORALL i IN l_hold_entity_id1.first..l_hold_entity_id1.last
8555:
8556: update HZ_CUSTOMER_PROFILES
8557: set credit_hold = 'Y'
8558: where CUST_ACCOUNT_ID = to_number(l_hold_entity_id1(i))
8559: and SITE_USE_ID IS NULL
8560: and l_hold_release_id1(i) IS NULL