DBA Data[Home] [Help]

APPS.OKL_INVESTOR_BILLING_PVT dependencies on OKX_CUST_SITE_USES_V

Line 106: ,okx_cust_site_uses_v B

102: --ADDED FOR RULES MIGRATION
103: CURSOR bill_site_rul_csr( p_invstr_agr_id NUMBER, p_top_line_id NUMBER ) IS
104: SELECT B.cust_acct_site_id
105: FROM okc_k_lines_b A
106: ,okx_cust_site_uses_v B
107: WHERE /*A.chr_id = p_invstr_agr_id
108: and A.cle_id IS NULL
109: and*/ A.id = p_top_line_id
110: and A.bill_to_site_use_id = B.id1;

Line 115: FROM okx_cust_site_uses_v

111:
112: --COMMENTED OUT FOR RULES MIGRATION
113: /*CURSOR bill_site_csr(p_id1 NUMBER, p_party_id NUMBER ) IS
114: SELECT cust_acct_site_id
115: FROM okx_cust_site_uses_v
116: WHERE id1 = p_id1 AND
117: PARTY_ID = p_party_id;*/
118:
119: -- nikshah -- Bug # 5484903 Fixed,