DBA Data[Home] [Help]

APPS.CN_IMP_TRXAPI_PVT dependencies on DUAL

Line 675: SELECT to_number(l_trxapi_imp.split_pct) into l_temp from dual;

671:
672: -- Checking split pct value is number or not
673: BEGIN
674: if l_trxapi_imp.split_pct is not null then
675: SELECT to_number(l_trxapi_imp.split_pct) into l_temp from dual;
676: end if;
677:
678: EXCEPTION
679:

Line 783: SELECT cn_comm_lines_api_s.NEXTVAL INTO l_comm_lines_api_id FROM dual;

779:
780: END IF;
781:
782: -- insert into cn_comm_lines_api
783: SELECT cn_comm_lines_api_s.NEXTVAL INTO l_comm_lines_api_id FROM dual;
784:
785: INSERT INTO cn_comm_lines_api
786: (ORG_ID,
787: comm_lines_api_id,