APPS.FII_AR_ACCOUNT_MERGE_PKG dependencies on FII_AR_RECEIPTS_F

Line 137: --FII_AR_RECEIPTS_F

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);
136:
137: --FII_AR_RECEIPTS_F
138: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
139: UPDATE FII_AR_RECEIPTS_F yt
140: SET BILL_TO_CUSTOMER_ID = NUM_COL1_NEW_LIST(I),
141: BILL_TO_SITE_USE_ID = NUM_COL2_NEW_LIST(I)

Line 139: UPDATE FII_AR_RECEIPTS_F yt

135: AND BILL_TO_SITE_USE_ID = NUM_COL2_ORIG_LIST(I);
136:
137: --FII_AR_RECEIPTS_F
138: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
139: UPDATE FII_AR_RECEIPTS_F yt
140: SET BILL_TO_CUSTOMER_ID = NUM_COL1_NEW_LIST(I),
141: BILL_TO_SITE_USE_ID = NUM_COL2_NEW_LIST(I)
142: WHERE BILL_TO_CUSTOMER_ID = NUM_COL1_ORIG_LIST(I)
143: AND BILL_TO_SITE_USE_ID = NUM_COL2_ORIG_LIST(I);

Line 145: --FII_AR_RECEIPTS_F (Collector_bill_to)

141: BILL_TO_SITE_USE_ID = NUM_COL2_NEW_LIST(I)
142: WHERE BILL_TO_CUSTOMER_ID = NUM_COL1_ORIG_LIST(I)
143: AND BILL_TO_SITE_USE_ID = NUM_COL2_ORIG_LIST(I);
144:
145: --FII_AR_RECEIPTS_F (Collector_bill_to)
146: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
147: UPDATE FII_AR_RECEIPTS_F yt
148: SET COLLECTOR_BILL_TO_CUSTOMER_ID = NUM_COL1_NEW_LIST(I),
149: COLLECTOR_BILL_TO_SITE_USE_ID = NUM_COL2_NEW_LIST(I)

Line 147: UPDATE FII_AR_RECEIPTS_F yt

143: AND BILL_TO_SITE_USE_ID = NUM_COL2_ORIG_LIST(I);
144:
145: --FII_AR_RECEIPTS_F (Collector_bill_to)
146: FORALL I in 1..MERGE_HEADER_ID_LIST.COUNT
147: UPDATE FII_AR_RECEIPTS_F yt
148: SET COLLECTOR_BILL_TO_CUSTOMER_ID = NUM_COL1_NEW_LIST(I),
149: COLLECTOR_BILL_TO_SITE_USE_ID = NUM_COL2_NEW_LIST(I)
150: WHERE COLLECTOR_BILL_TO_CUSTOMER_ID = NUM_COL1_ORIG_LIST(I)
151: AND COLLECTOR_BILL_TO_SITE_USE_ID = NUM_COL2_ORIG_LIST(I);