APPS.OKS_BILLING_PROFILES_PVT dependencies on OKX_CUST_SITE_USES_V

Line 1069: FROM Okx_Cust_Site_Uses_V

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:

Line 1070: WHERE okx_cust_site_uses_v.id1 = p_id1

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

Line 1071: AND okx_cust_site_uses_v.id2 = p_id2;

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'