DBA Data[Home] [Help]

APPS.AR_CMGT_CREDIT_REQUEST_API dependencies on DUAL

Line 572: FROM DUAL;

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;
575:
576: IF l_credit_request_id IS NULL THEN

Line 579: FROM dual;

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:
582: /*-----------------------------------------+
583: | VALIDATION |