DBA Data[Home] [Help]

APPS.OKL_DEAL_ASSET_PVT dependencies on CSI_ITEM_INSTANCES

Line 809: -- This cursor is used to get Install Site from CSI_ITEM_INSTANCES for Active Contract

805: --Bug# 9721029
806: l_install_site_rec c_install_site%ROWTYPE;
807:
808: -- gboomina added - Start
809: -- This cursor is used to get Install Site from CSI_ITEM_INSTANCES for Active Contract
810: -- vsgandhi 17-Aug-2011 Fixed Bug 12783759
811: -- Passed p_clev_fin_id to cursor to get the install site name
812:
813: CURSOR c_install_site_active(p_chr_id NUMBER, p_clev_fin_id NUMBER) IS

Line 821: csi_item_instances csi,

817: hl.postal_code,null,hl.country,null, null,null,null,null,null,
818: null,'n','n',80,1,1),1,80) party_site_name
819: from hz_locations hl,
820: hz_party_sites hps,
821: csi_item_instances csi,
822: okc_k_items cim_ib,
823: okc_line_styles_b lse_ib,
824: okc_k_lines_b cle_ib,
825: okc_line_styles_b lse_inst,