APPS.AHL_UC_INSTANCE_PVT dependencies on CSI_IP_ACCOUNTS

Line 2366: CURSOR csi_ip_accounts_csr(c_instance_party_id IN NUMBER) IS

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

Line 2368: FROM csi_ip_accounts

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

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

2932: l_csi_party_tbl(1) := l_csi_party_rec;
2933:
2934: --dbms_output.put_line('before build accounts:...');
2935: --Build CSI accounts table.
2936: FOR party_ip_acct IN csi_ip_accounts_csr(l_uc_owner_loc_rec.instance_party_id)
2937: LOOP
2938: l_party_account_rec.party_account_id := party_ip_acct.party_account_id;
2939: l_party_account_rec.relationship_type_code := 'OWNER';
2940: l_party_account_rec.parent_tbl_index := 1;

Line 6125: CURSOR csi_ip_accounts_csr(p_instance_party_id NUMBER) IS

6121: AND p.relationship_type_code = 'OWNER'
6122: AND csi.instance_id = p_csi_instance_id
6123: AND trunc(nvl(csi.active_end_date, SYSDATE+1)) > trunc(SYSDATE);
6124:
6125: CURSOR csi_ip_accounts_csr(p_instance_party_id NUMBER) IS
6126: SELECT party_account_id
6127: FROM csi_ip_accounts
6128: WHERE relationship_type_code = 'OWNER'
6129: AND instance_party_id = p_instance_party_id

Line 6127: FROM csi_ip_accounts

6123: AND trunc(nvl(csi.active_end_date, SYSDATE+1)) > trunc(SYSDATE);
6124:
6125: CURSOR csi_ip_accounts_csr(p_instance_party_id NUMBER) IS
6126: SELECT party_account_id
6127: FROM csi_ip_accounts
6128: WHERE relationship_type_code = 'OWNER'
6129: AND instance_party_id = p_instance_party_id
6130: AND trunc(nvl(active_start_date, SYSDATE)) <= trunc(SYSDATE)
6131: AND trunc(nvl(active_end_date, SYSDATE+1)) > trunc(SYSDATE);

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

6378: l_csi_party_rec.contact_flag := 'N';
6379: l_csi_party_tbl(1) := l_csi_party_rec;
6380:
6381: -- Build CSI accounts table
6382: FOR party_ip_acct IN csi_ip_accounts_csr(l_uc_owner_loc_rec.instance_party_id)
6383: LOOP
6384: IF (FND_LOG.LEVEL_STATEMENT >= FND_LOG.G_CURRENT_RUNTIME_LEVEL) THEN
6385: FND_LOG.STRING(FND_LOG.LEVEL_STATEMENT, l_full_name,
6386: ' i => '||i||