DBA Data[Home] [Help]

APPS.FII_AR_ACCOUNT_MERGE_PKG dependencies on FII_AR_TRANSACTIONS_F

Line 129: --FII_AR_TRANSACTIONS_F

125: SET BILL_TO_CUSTOMER_ID=NUM_COL1_NEW_LIST(I),
126: BILL_TO_SITE_USE_ID=NUM_COL2_NEW_LIST(I)
127: WHERE PAYMENT_SCHEDULE_ID=PRIMARY_KEY_ID_LIST(I);
128:
129: --FII_AR_TRANSACTIONS_F
130: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
131: UPDATE FII_AR_TRANSACTIONS_F yt
132: SET BILL_TO_CUSTOMER_ID = NUM_COL1_NEW_LIST(I),
133: BILL_TO_SITE_USE_ID = NUM_COL2_NEW_LIST(I)

Line 131: UPDATE FII_AR_TRANSACTIONS_F yt

127: WHERE PAYMENT_SCHEDULE_ID=PRIMARY_KEY_ID_LIST(I);
128:
129: --FII_AR_TRANSACTIONS_F
130: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
131: UPDATE FII_AR_TRANSACTIONS_F yt
132: SET BILL_TO_CUSTOMER_ID = NUM_COL1_NEW_LIST(I),
133: BILL_TO_SITE_USE_ID = NUM_COL2_NEW_LIST(I)
134: WHERE BILL_TO_CUSTOMER_ID = NUM_COL1_ORIG_LIST(I)
135: AND BILL_TO_SITE_USE_ID = NUM_COL2_ORIG_LIST(I);