APPS.AR_CMGT_CONTROLS dependencies on AR_CMGT_COLLATERAL_DATA

Line 1425: INSERT INTO ar_cmgt_collateral_data

1421: IF l_processing_flag = 'Y'
1422: THEN
1423: BEGIN
1424:
1425: INSERT INTO ar_cmgt_collateral_data
1426: (DATAPOINT_ID,
1427: CREDIT_REQUEST_ID,
1428: LAST_UPDATE_DATE,
1429: LAST_UPDATED_BY,

Line 1445: ( SELECT AR_CMGT_COLLATERAL_DATA_S.NEXTVAL,

1441: APPRAISER_PHONE_NUMBER,
1442: COLLATERAL_LOCATION,
1443: CASE_FOLDER_ID,
1444: NOTES)
1445: ( SELECT AR_CMGT_COLLATERAL_DATA_S.NEXTVAL,
1446: l_credit_request_id,
1447: SYSDATE,
1448: fnd_global.user_id,
1449: SYSDATE,

Line 1464: FROM ar_cmgt_collateral_data

1460: APPRAISER_PHONE_NUMBER,
1461: COLLATERAL_LOCATION,
1462: nvl(l_case_folders_id,-99),
1463: NOTES
1464: FROM ar_cmgt_collateral_data
1465: WHERE CREDIT_REQUEST_ID = p_parnt_credit_req_id);
1466:
1467: EXCEPTION
1468: WHEN OTHERS