APPS.CSI_PARTY_RELATIONSHIPS_PUB dependencies on CSI_I_PARTIES

Line 47: ' FROM CSI_I_PARTIES ';

43: ' active_end_date, context,attribute1,attribute2,attribute3, attribute4,attribute5, '||
44: ' attribute6, attribute7, attribute8, attribute9, attribute10 ,attribute11, '||
45: ' attribute12,attribute13,attribute14,attribute15 ,object_version_number, '||
46: ' primary_flag, preferred_flag'||
47: ' FROM CSI_I_PARTIES ';
48: l_pty_name VARCHAR2(360);
49:
50: BEGIN
51: -- Standard Start of API savepoint

Line 752: ,csi_i_parties pty

748: SELECT acct.party_account_id
749: ,acct.active_end_date
750: ,pty.instance_id
751: FROM csi_ip_accounts acct
752: ,csi_i_parties pty
753: WHERE acct.instance_party_id = p_ins_pty_id
754: AND acct.relationship_type_code = 'OWNER'
755: AND ((acct.active_end_date IS NULL) OR (acct.active_end_date>SYSDATE))
756: AND pty.instance_party_id= acct.instance_party_id;

Line 772: FROM csi_i_parties

768:
769: CURSOR old_party_csr (p_ins_pty_id IN NUMBER) IS
770: SELECT instance_party_id,
771: party_id
772: FROM csi_i_parties
773: WHERE instance_party_id = p_ins_pty_id
774: AND relationship_type_code = 'OWNER'
775: AND (active_end_date IS NULL OR active_end_date > sysdate);
776:

Line 783: FROM csi_i_parties

779: party_id,
780: relationship_type_code,
781: object_version_number,
782: active_end_date -- Added for bug 7333900
783: FROM csi_i_parties
784: WHERE instance_id = p_ins_id
785: AND relationship_type_code<>'OWNER'
786: AND (active_end_date IS NULL
787: OR (trunc(active_end_date,'MI') > trunc(sysdate,'MI'))); -- Modified for bug 7333900 -- changed to trunc for bug 12564475

Line 1553: FROM csi_i_parties

1549: THEN
1550: BEGIN
1551: SELECT instance_id
1552: INTO l_old_party_tbl(l_old_party_row).instance_id
1553: FROM csi_i_parties
1554: WHERE instance_party_id=l_old_party_tbl(l_old_party_row).instance_party_id;
1555: EXCEPTION
1556: WHEN NO_DATA_FOUND THEN
1557: NULL;

Line 1607: FROM csi_i_parties

1603: INTO l_cld_party_rec.instance_party_id,
1604: l_cld_party_rec.instance_id,
1605: l_cld_party_id,
1606: l_cld_party_rec.object_version_number
1607: FROM csi_i_parties
1608: WHERE instance_id = l_rel_tbl(j).subject_id
1609: AND relationship_type_code = 'OWNER'
1610: AND (active_end_date IS NULL OR active_end_date > SYSDATE);
1611:

Line 2537: FROM csi_i_parties

2533: SELECT subject_id
2534: FROM csi_ii_relationships
2535: WHERE relationship_type_code = 'COMPONENT-OF'
2536: START WITH object_id = (SELECT instance_id+0
2537: FROM csi_i_parties
2538: WHERE instance_party_id = p_ins_pty_id
2539: AND relationship_type_code = 'OWNER'
2540: AND (active_end_date IS NULL OR active_end_date > sysdate)
2541: )

Line 2631: csi_i_parties pty

2627: INTO l_temp_account_tbl(l_acct_row).ip_account_id,
2628: l_temp_account_tbl(l_acct_row).party_account_id,
2629: l_temp_account_tbl(l_acct_row).attribute1
2630: FROM csi_ip_accounts acct,
2631: csi_i_parties pty
2632: WHERE acct.ip_account_id = p_party_account_tbl(l_count).ip_account_id
2633: AND acct.instance_party_id = pty.instance_party_id;
2634:
2635: l_acct_row := l_acct_row+1;

Line 2708: from CSI_I_PARTIES

2704: l_object_id := null;
2705: Begin
2706: select instance_id
2707: into l_object_id
2708: from CSI_I_PARTIES
2709: where instance_party_id = l_party_account_tbl(l_old_party_row).instance_party_id
2710: and relationship_type_code = 'OWNER'
2711: and (active_end_date IS NULL OR active_end_date > sysdate);
2712: Exception

Line 2757: csi_i_parties pty

2753: INTO l_party_account_tbl(l_old_party_row).ip_account_id,
2754: l_party_account_tbl(l_old_party_row).object_version_number,
2755: l_party_id
2756: FROM csi_ip_accounts acct,
2757: csi_i_parties pty
2758: WHERE pty.instance_party_id = acct.instance_party_id
2759: AND pty.instance_id = l_rel_tbl(j).subject_id
2760: AND acct.relationship_type_code = 'OWNER'
2761: AND (acct.active_end_date IS NULL OR