APPS.OKC_XPRT_XRULE_VALUES_PVT dependencies on OKC_XPRT_DEVIATIONS_T

Line 739: FROM okc_xprt_deviations_t

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

Line 745: FROM okc_xprt_deviations_t

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

Line 779: INSERT INTO OKC_XPRT_DEVIATIONS_T

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