APPS.AHL_UC_INSTANCE_PVT dependencies on CSI_IP_ACCOUNTS

Line 2367: CURSOR csi_ip_accounts_csr(c_instance_party_id IN NUMBER) IS

2363: AND csi.instance_id = c_csi_instance_id
2364: AND trunc(SYSDATE) < trunc(nvl(csi.active_end_date, SYSDATE+1));
2365: l_uc_owner_loc_rec csi_item_instance_csr%ROWTYPE;
2366:
2367: CURSOR csi_ip_accounts_csr(c_instance_party_id IN NUMBER) IS
2368: SELECT party_account_id
2369: FROM csi_ip_accounts
2370: WHERE relationship_type_code = 'OWNER'
2371: AND instance_party_id = c_instance_party_id

Line 2369: FROM csi_ip_accounts

2365: l_uc_owner_loc_rec csi_item_instance_csr%ROWTYPE;
2366:
2367: CURSOR csi_ip_accounts_csr(c_instance_party_id IN NUMBER) IS
2368: SELECT party_account_id
2369: FROM csi_ip_accounts
2370: WHERE relationship_type_code = 'OWNER'
2371: AND instance_party_id = c_instance_party_id
2372: AND trunc(SYSDATE) >= trunc(nvl(active_start_date, SYSDATE))
2373: AND trunc(SYSDATE) < trunc(nvl(active_end_date, SYSDATE+1));

Line 2942: FOR party_ip_acct IN csi_ip_accounts_csr(l_uc_owner_loc_rec.instance_party_id)

2938: l_csi_party_tbl(1) := l_csi_party_rec;
2939:
2940: --dbms_output.put_line('before build accounts:...');
2941: --Build CSI accounts table.
2942: FOR party_ip_acct IN csi_ip_accounts_csr(l_uc_owner_loc_rec.instance_party_id)
2943: LOOP
2944: l_party_account_rec.party_account_id := party_ip_acct.party_account_id;
2945: l_party_account_rec.relationship_type_code := 'OWNER';
2946: l_party_account_rec.parent_tbl_index := 1;

Line 6232: CURSOR csi_ip_accounts_csr(p_instance_party_id NUMBER) IS

6228: AND p.relationship_type_code = 'OWNER'
6229: AND csi.instance_id = p_csi_instance_id
6230: AND trunc(nvl(csi.active_end_date, SYSDATE+1)) > trunc(SYSDATE);
6231:
6232: CURSOR csi_ip_accounts_csr(p_instance_party_id NUMBER) IS
6233: SELECT party_account_id
6234: FROM csi_ip_accounts
6235: WHERE relationship_type_code = 'OWNER'
6236: AND instance_party_id = p_instance_party_id

Line 6234: FROM csi_ip_accounts

6230: AND trunc(nvl(csi.active_end_date, SYSDATE+1)) > trunc(SYSDATE);
6231:
6232: CURSOR csi_ip_accounts_csr(p_instance_party_id NUMBER) IS
6233: SELECT party_account_id
6234: FROM csi_ip_accounts
6235: WHERE relationship_type_code = 'OWNER'
6236: AND instance_party_id = p_instance_party_id
6237: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
6238: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);

Line 6489: FOR party_ip_acct IN csi_ip_accounts_csr(l_uc_owner_loc_rec.instance_party_id)

6485: l_csi_party_rec.contact_flag := 'N';
6486: l_csi_party_tbl(1) := l_csi_party_rec;
6487:
6488: -- Build CSI accounts table
6489: FOR party_ip_acct IN csi_ip_accounts_csr(l_uc_owner_loc_rec.instance_party_id)
6490: LOOP
6491: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6492: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
6493: ' i => '||i||