APPS.OKC_XPRT_XRULE_VALUES_PVT dependencies on OKC_XPRT_DEVIATIONS_T

Line 738: FROM okc_xprt_deviations_t

734: GROUP BY rcon.object_value_code);
735:
736: CURSOR csr_get_uniq_proc (p_sequence_id NUMBER) IS
737: SELECT distinct procedure_name procedure_name
738: FROM okc_xprt_deviations_t
739: WHERE run_id = p_sequence_id;
740:
741:
742: CURSOR csr_get_vars_for_proc (p_procedure_name VARCHAR2, p_sequence_id NUMBER) IS

Line 744: FROM okc_xprt_deviations_t

740:
741:
742: CURSOR csr_get_vars_for_proc (p_procedure_name VARCHAR2, p_sequence_id NUMBER) IS
743: SELECT distinct variable_code variable_code
744: FROM okc_xprt_deviations_t
745: WHERE run_id = p_sequence_id
746: AND procedure_name = p_procedure_name;
747:
748: l_api_name VARCHAR2(30) := 'get_udv_with_procedures';

Line 775: INSERT INTO OKC_XPRT_DEVIATIONS_T

771: SELECT OKC_TERMS_DEVIATIONS_S1.nextval INTO l_sequence_id from DUAL;
772:
773: FOR csr_get_udv_with_proc_rec IN csr_get_udv_with_proc(p_doc_type, p_doc_id, p_intent, p_org_id)
774: LOOP
775: INSERT INTO OKC_XPRT_DEVIATIONS_T
776: (
777: RUN_ID,
778: LINE_NUMBER,
779: VARIABLE_CODE,