DBA Data[Home] [Help]

APPS.FII_AR_ACCOUNT_MERGE_PKG dependencies on FII_AR_DISPUTE_HISTORY_F

Line 161: --FII_AR_DISPUTE_HISTORY_F

157: BILL_TO_SITE_USE_ID = NUM_COL2_NEW_LIST(I)
158: WHERE BILL_TO_CUSTOMER_ID = NUM_COL1_ORIG_LIST(I)
159: AND BILL_TO_SITE_USE_ID = NUM_COL2_ORIG_LIST(I);
160:
161: --FII_AR_DISPUTE_HISTORY_F
162: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
163: UPDATE FII_AR_DISPUTE_HISTORY_F yt
164: SET BILL_TO_CUSTOMER_ID = NUM_COL1_NEW_LIST(I),
165: BILL_TO_SITE_USE_ID = NUM_COL2_NEW_LIST(I)

Line 163: UPDATE FII_AR_DISPUTE_HISTORY_F yt

159: AND BILL_TO_SITE_USE_ID = NUM_COL2_ORIG_LIST(I);
160:
161: --FII_AR_DISPUTE_HISTORY_F
162: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
163: UPDATE FII_AR_DISPUTE_HISTORY_F yt
164: SET BILL_TO_CUSTOMER_ID = NUM_COL1_NEW_LIST(I),
165: BILL_TO_SITE_USE_ID = NUM_COL2_NEW_LIST(I)
166: WHERE BILL_TO_CUSTOMER_ID = NUM_COL1_ORIG_LIST(I)
167: AND BILL_TO_SITE_USE_ID = NUM_COL2_ORIG_LIST(I);