APPS.AR_CMGT_CONTROLS dependencies on AR_CMGT_CF_ANL_NOTES

Line 1699: INSERT INTO AR_CMGT_CF_ANL_NOTES

1695: IF l_processing_flag = 'Y'
1696: THEN
1697:
1698: BEGIN
1699: INSERT INTO AR_CMGT_CF_ANL_NOTES
1700: (ANALYSIS_NOTES_ID,
1701: CASE_FOLDER_ID,
1702: LAST_UPDATED_BY,
1703: LAST_UPDATE_DATE,

Line 1712: (SELECT AR_CMGT_CF_ANL_NOTES_S.NEXTVAL,

1708: DISPLAY,
1709: IMPORTANCE,
1710: NOTES,
1711: DATE_OPENED)
1712: (SELECT AR_CMGT_CF_ANL_NOTES_S.NEXTVAL,
1713: l_case_folders_id,
1714: fnd_global.user_id,
1715: sysdate,
1716: fnd_global.login_id,

Line 1724: FROM AR_CMGT_CF_ANL_NOTES

1720: DISPLAY,
1721: IMPORTANCE,
1722: NOTES,
1723: DATE_OPENED
1724: FROM AR_CMGT_CF_ANL_NOTES
1725: WHERE CASE_FOLDER_ID= p_parnt_case_folder_id);
1726: EXCEPTION
1727: WHEN OTHERS
1728: THEN