APPS.AHL_CMP_PVT dependencies on CSI_IP_ACCOUNTS

Line 2878: CURSOR get_csi_ip_accounts_det_csr(c_instance_party_id NUMBER) IS

2874: AND trunc(nvl(c.active_start_date, SYSDATE)) <= trunc(SYSDATE)
2875: AND trunc(nvl(c.active_end_date, SYSDATE+1)) > trunc(SYSDATE);
2876:
2877: -- cursor to get instance accounts details
2878: CURSOR get_csi_ip_accounts_det_csr(c_instance_party_id NUMBER) IS
2879: SELECT party_account_id
2880: FROM csi_ip_accounts
2881: WHERE relationship_type_code = 'OWNER'
2882: AND instance_party_id = c_instance_party_id

Line 2880: FROM csi_ip_accounts

2876:
2877: -- cursor to get instance accounts details
2878: CURSOR get_csi_ip_accounts_det_csr(c_instance_party_id NUMBER) IS
2879: SELECT party_account_id
2880: FROM csi_ip_accounts
2881: WHERE relationship_type_code = 'OWNER'
2882: AND instance_party_id = c_instance_party_id
2883: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
2884: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);

Line 2984: FOR l_csi_ip_accounts_det IN get_csi_ip_accounts_det_csr(l_csi_item_instance_det.instance_party_id)

2980: l_csi_party_rec.contact_flag := 'N';
2981: l_csi_party_tbl(1) := l_csi_party_rec;
2982:
2983: -- Build CSI accounts table
2984: FOR l_csi_ip_accounts_det IN get_csi_ip_accounts_det_csr(l_csi_item_instance_det.instance_party_id)
2985: LOOP
2986: l_party_account_rec.party_account_id := l_csi_ip_accounts_det.party_account_id;
2987: l_party_account_rec.relationship_type_code := 'OWNER';
2988: l_party_account_rec.parent_tbl_index := 1;

Line 2986: l_party_account_rec.party_account_id := l_csi_ip_accounts_det.party_account_id;

2982:
2983: -- Build CSI accounts table
2984: FOR l_csi_ip_accounts_det IN get_csi_ip_accounts_det_csr(l_csi_item_instance_det.instance_party_id)
2985: LOOP
2986: l_party_account_rec.party_account_id := l_csi_ip_accounts_det.party_account_id;
2987: l_party_account_rec.relationship_type_code := 'OWNER';
2988: l_party_account_rec.parent_tbl_index := 1;
2989: l_index := l_index + 1;
2990: l_csi_account_tbl(l_index) := l_party_account_rec;