DBA Data[Home] [Help]

APPS.FII_AR_ACCOUNT_MERGE_PKG dependencies on FII_AR_AGING_RECEIPTS

Line 177: --FII_AR_AGING_RECEIPTS

173: BILL_TO_SITE_USE_ID = NUM_COL2_NEW_LIST(I)
174: WHERE BILL_TO_CUSTOMER_ID = NUM_COL1_ORIG_LIST(I)
175: AND BILL_TO_SITE_USE_ID = NUM_COL2_ORIG_LIST(I);
176:
177: --FII_AR_AGING_RECEIPTS
178: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
179: UPDATE FII_AR_AGING_RECEIPTS yt
180: SET BILL_TO_CUSTOMER_ID = NUM_COL1_NEW_LIST(I),
181: BILL_TO_SITE_USE_ID = NUM_COL2_NEW_LIST(I)

Line 179: UPDATE FII_AR_AGING_RECEIPTS yt

175: AND BILL_TO_SITE_USE_ID = NUM_COL2_ORIG_LIST(I);
176:
177: --FII_AR_AGING_RECEIPTS
178: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
179: UPDATE FII_AR_AGING_RECEIPTS yt
180: SET BILL_TO_CUSTOMER_ID = NUM_COL1_NEW_LIST(I),
181: BILL_TO_SITE_USE_ID = NUM_COL2_NEW_LIST(I)
182: WHERE BILL_TO_CUSTOMER_ID = NUM_COL1_ORIG_LIST(I)
183: AND BILL_TO_SITE_USE_ID = NUM_COL2_ORIG_LIST(I);