1065:
1066: CURSOR okx_site_uses_v_pk_csr (p_id1 IN NUMBER,
1067: p_id2 IN VARCHAR2) IS
1068: SELECT 'x'
1069: FROM Okx_Cust_Site_Uses_V
1070: WHERE okx_cust_site_uses_v.id1 = p_id1
1071: AND okx_cust_site_uses_v.id2 = p_id2;
1072: l_okx_site_uses_v_pk okx_site_uses_v_pk_csr%ROWTYPE;
1073:
1066: CURSOR okx_site_uses_v_pk_csr (p_id1 IN NUMBER,
1067: p_id2 IN VARCHAR2) IS
1068: SELECT 'x'
1069: FROM Okx_Cust_Site_Uses_V
1070: WHERE okx_cust_site_uses_v.id1 = p_id1
1071: AND okx_cust_site_uses_v.id2 = p_id2;
1072: l_okx_site_uses_v_pk okx_site_uses_v_pk_csr%ROWTYPE;
1073:
1074: CURSOR bpev_fndv_mda_fk_csr (p_lookup_code IN VARCHAR2) IS
1067: p_id2 IN VARCHAR2) IS
1068: SELECT 'x'
1069: FROM Okx_Cust_Site_Uses_V
1070: WHERE okx_cust_site_uses_v.id1 = p_id1
1071: AND okx_cust_site_uses_v.id2 = p_id2;
1072: l_okx_site_uses_v_pk okx_site_uses_v_pk_csr%ROWTYPE;
1073:
1074: CURSOR bpev_fndv_mda_fk_csr (p_lookup_code IN VARCHAR2) IS
1075: SELECT 'x'