eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.AR_CMGT_UTIL dependencies on AR_CMGT_CHECK_LISTS

Line 463: ar_cmgt_check_lists cl

459:
460: CURSOR c_number_of_reference IS
461: SELECT cld.number_of_references
462: FROM ar_cmgt_check_list_dtls cld,
463: ar_cmgt_check_lists cl
464: WHERE cl.check_list_id = cld.check_list_id
465: AND cld.data_point_id = p_data_point_id
466: AND cl.credit_classification = p_credit_classification
467: AND cl.review_type = p_review_type

Line 673: FROM ar_cmgt_check_lists

669: return VARCHAR2 IS
670:
671: CURSOR c_dup_checklist IS
672: SELECT Check_list_name
673: FROM ar_cmgt_check_lists
674: WHERE submit_flag = 'Y'
675: AND credit_classification = p_credit_classification
676: AND review_type = p_review_type
677: AND nvl(end_date,SYSDATE) >= p_start_date;

Line 679: l_check_list_name ar_cmgt_check_lists.check_list_name%type;

675: AND credit_classification = p_credit_classification
676: AND review_type = p_review_type
677: AND nvl(end_date,SYSDATE) >= p_start_date;
678:
679: l_check_list_name ar_cmgt_check_lists.check_list_name%type;
680:
681: BEGIN
682: OPEN c_dup_checklist;
683: