APPS.AR_CMGT_CONTROLS dependencies on AR_CMGT_BANK_REF_ACCTS

Line 1340: INSERT INTO AR_CMGT_BANK_REF_ACCTS

1336:
1337: -- duplicate the account details.
1338:
1339:
1340: INSERT INTO AR_CMGT_BANK_REF_ACCTS
1341: (BANK_REFERENCE_ACCOUNT_ID,
1342: DATAPOINT_ID,
1343: CREDIT_REQUEST_ID,
1344: LAST_UPDATE_DATE,

Line 1356: ( SELECT AR_CMGT_BANK_REF_ACCTS_S.NEXTVAL,

1352: CURRENCY,
1353: CURRENT_BALANCE,
1354: BALANCE_DATE,
1355: AVERAGE_BALANCE)
1356: ( SELECT AR_CMGT_BANK_REF_ACCTS_S.NEXTVAL,
1357: l_next_val,
1358: l_credit_request_id,
1359: SYSDATE,
1360: fnd_global.user_id,

Line 1371: FROM AR_CMGT_BANK_REF_ACCTS

1367: CURRENCY,
1368: CURRENT_BALANCE,
1369: BALANCE_DATE,
1370: AVERAGE_BALANCE
1371: FROM AR_CMGT_BANK_REF_ACCTS
1372: WHERE CREDIT_REQUEST_ID= p_parnt_credit_req_id
1373: AND DATAPOINT_ID = l_data_point_id);
1374:
1375: