APPS.CN_CUST_MERGE_PVT dependencies on CN_COMMISSION_HEADERS_ALL

Line 45: FROM CN_COMMISSION_HEADERS_ALL yt, ra_customer_merges m

41: ,yt.COMMISSION_HEADER_ID
42: ,yt.CUSTOMER_ID
43: ,yt.BILL_TO_ADDRESS_ID
44: ,yt.SHIP_TO_ADDRESS_ID
45: FROM CN_COMMISSION_HEADERS_ALL yt, ra_customer_merges m
46: WHERE (
47: yt.CUSTOMER_ID = m.DUPLICATE_ID
48: OR ((yt.BILL_TO_ADDRESS_ID = m.DUPLICATE_ADDRESS_ID)
49: AND

Line 198: UPDATE CN_COMMISSION_HEADERS_ALL yt SET

194: hz_utility_pub.LAST_UPDATED_BY
195: );
196: END IF;
197: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
198: UPDATE CN_COMMISSION_HEADERS_ALL yt SET
199: CUSTOMER_ID=NUM_COL1_NEW_LIST(I)
200: ,BILL_TO_ADDRESS_ID=NUM_COL2_NEW_LIST(I)
201: ,SHIP_TO_ADDRESS_ID=NUM_COL3_NEW_LIST(I)
202: , LAST_UPDATE_DATE=SYSDATE