APPS.AR_CMGT_CREDIT_REQUEST_API dependencies on AR_CMGT_CREDIT_REQUESTS_S

Line 570: SELECT AR_CMGT_APPLICATION_NUM_S.NEXTVAL, AR_CMGT_CREDIT_REQUESTS_S.NEXTVAL

566:
567: IF l_application_number IS NULL
568: AND nvl(l_sys_params_rec.auto_application_num_flag, 'N') = 'Y'
569: THEN
570: SELECT AR_CMGT_APPLICATION_NUM_S.NEXTVAL, AR_CMGT_CREDIT_REQUESTS_S.NEXTVAL
571: INTO l_application_number, l_credit_request_id
572: FROM DUAL;
573:
574: END IF;

Line 577: SELECT AR_CMGT_CREDIT_REQUESTS_S.NEXTVAL

573:
574: END IF;
575:
576: IF l_credit_request_id IS NULL THEN
577: SELECT AR_CMGT_CREDIT_REQUESTS_S.NEXTVAL
578: INTO l_credit_request_id
579: FROM dual;
580: END IF;
581: