DBA Data[Home] [Help]

APPS.AR_CMGT_UTIL dependencies on AR_CMGT_CHECK_LIST_DTLS

Line 462: FROM ar_cmgt_check_list_dtls cld,

458: p_value OUT NOCOPY VARCHAR2 ) IS
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

Line 635: FROM ar_cmgt_check_list_dtls

631: CURSOR c_data_points IS
632: SELECT data_point_id,
633: required_flag,
634: number_of_references
635: FROM ar_cmgt_check_list_dtls
636: WHERE check_list_id = p_old_check_list_id;
637: BEGIN
638: FOR c_data_points_rec IN c_data_points
639: LOOP

Line 640: INSERT INTO ar_cmgt_check_list_dtls

636: WHERE check_list_id = p_old_check_list_id;
637: BEGIN
638: FOR c_data_points_rec IN c_data_points
639: LOOP
640: INSERT INTO ar_cmgt_check_list_dtls
641: (check_list_id,
642: data_point_id,
643: number_of_references,
644: required_flag,