APPS.AR_CMGT_CONTROLS dependencies on AR_CMGT_FINANCIAL_DATA

Line 1020: INSERT INTO AR_CMGT_FINANCIAL_DATA

1016: IF l_processing_flag = 'Y'
1017: THEN
1018: BEGIN
1019:
1020: INSERT INTO AR_CMGT_FINANCIAL_DATA
1021: (FINANCIAL_DATA_ID,
1022: CREDIT_REQUEST_ID,
1023: LAST_UPDATE_DATE,
1024: LAST_UPDATED_BY,

Line 1064: (SELECT AR_CMGT_FINANCIAL_DATA_S.nextval,

1060: CASE_FOLDER_ID,
1061: PARTY_ID,
1062: CUST_ACCOUNT_ID,
1063: SITE_USE_ID)
1064: (SELECT AR_CMGT_FINANCIAL_DATA_S.nextval,
1065: l_credit_request_id,
1066: SYSDATE,
1067: fnd_global.user_id,
1068: SYSDATE,

Line 1107: FROM AR_CMGT_FINANCIAL_DATA

1103: nvl(l_case_folders_id,-99),
1104: PARTY_ID,
1105: CUST_ACCOUNT_ID,
1106: SITE_USE_ID
1107: FROM AR_CMGT_FINANCIAL_DATA
1108: WHERE CREDIT_REQUEST_ID = p_parnt_credit_req_id);
1109:
1110: EXCEPTION
1111: WHEN OTHERS