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 795: FROM dual;

791: BEGIN
792:
793: SELECT to_number(l_trxapi_imp.order_number)
794: INTO l_order_num
795: FROM dual;
796:
797: EXCEPTION
798: WHEN OTHERS
799: THEN

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

837:
838: -- End of addition
839:
840: -- insert into cn_comm_lines_api
841: SELECT cn_comm_lines_api_s.NEXTVAL INTO l_comm_lines_api_id FROM dual;
842:
843: INSERT INTO cn_comm_lines_api
844: (ORG_ID,
845: comm_lines_api_id,