DBA Data[Home] [Help]

APPS.OKL_MAINTAIN_CONTRACT_PVT dependencies on DUAL

Line 451: FROM DUAL;

447: IF (p_new_contract_number IS NULL) THEN
448: -- Get Sequence Number to generate Contract Number
449: SELECT okl_rbk_seq.NEXTVAL
450: INTO l_seq_no
451: FROM DUAL;
452:
453: l_new_contract_number := l_orig_contract_number || '-CANCEL'|| l_seq_no;
454: ELSE
455: l_new_contract_number := p_new_contract_number;