APPS.AR_CMGT_CONTROLS dependencies on AR_CMGT_TRADE_REF_DATA

Line 1156: INSERT INTO ar_cmgt_trade_ref_data

1152: THEN
1153:
1154: BEGIN
1155:
1156: INSERT INTO ar_cmgt_trade_ref_data
1157: (DATAPOINT_ID,
1158: CREDIT_REQUEST_ID,
1159: LAST_UPDATE_DATE,
1160: LAST_UPDATED_BY,

Line 1189: (SELECT AR_CMGT_TRADE_REF_DATA_S.NEXTVAL,

1185: PAST_DUE_AMOUNT,
1186: INTERNAL_TRADE_RATING,
1187: CASE_FOLDER_ID,
1188: NOTES)
1189: (SELECT AR_CMGT_TRADE_REF_DATA_S.NEXTVAL,
1190: l_credit_request_id,
1191: SYSDATE,
1192: fnd_global.user_id,
1193: SYSDATE,

Line 1221: FROM AR_CMGT_TRADE_REF_DATA

1217: PAST_DUE_AMOUNT,
1218: INTERNAL_TRADE_RATING,
1219: nvl(l_case_folders_id,-99),
1220: NOTES
1221: FROM AR_CMGT_TRADE_REF_DATA
1222: WHERE CREDIT_REQUEST_ID= p_parnt_credit_req_id);
1223:
1224: EXCEPTION
1225: WHEN OTHERS