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 750: ,csi_i_parties pty

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

Line 770: FROM csi_i_parties

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

Line 780: FROM csi_i_parties

776: SELECT instance_party_id,
777: party_id,
778: relationship_type_code,
779: object_version_number
780: FROM csi_i_parties
781: WHERE instance_id = p_ins_id
782: AND relationship_type_code<>'OWNER'
783: AND (active_end_date IS NULL OR active_end_date > sysdate);
784:

Line 1520: FROM csi_i_parties

1516: THEN
1517: BEGIN
1518: SELECT instance_id
1519: INTO l_old_party_tbl(l_old_party_row).instance_id
1520: FROM csi_i_parties
1521: WHERE instance_party_id=l_old_party_tbl(l_old_party_row).instance_party_id;
1522: EXCEPTION
1523: WHEN NO_DATA_FOUND THEN
1524: NULL;

Line 1574: FROM csi_i_parties

1570: INTO l_cld_party_rec.instance_party_id,
1571: l_cld_party_rec.instance_id,
1572: l_cld_party_id,
1573: l_cld_party_rec.object_version_number
1574: FROM csi_i_parties
1575: WHERE instance_id = l_rel_tbl(j).subject_id
1576: AND relationship_type_code = 'OWNER'
1577: AND (active_end_date IS NULL OR active_end_date > SYSDATE);
1578:

Line 2488: FROM csi_i_parties

2484: SELECT subject_id
2485: FROM csi_ii_relationships
2486: WHERE relationship_type_code = 'COMPONENT-OF'
2487: START WITH object_id = (SELECT instance_id+0
2488: FROM csi_i_parties
2489: WHERE instance_party_id = p_ins_pty_id
2490: AND relationship_type_code = 'OWNER'
2491: AND (active_end_date IS NULL OR active_end_date > sysdate)
2492: )

Line 2582: csi_i_parties pty

2578: INTO l_temp_account_tbl(l_acct_row).ip_account_id,
2579: l_temp_account_tbl(l_acct_row).party_account_id,
2580: l_temp_account_tbl(l_acct_row).attribute1
2581: FROM csi_ip_accounts acct,
2582: csi_i_parties pty
2583: WHERE acct.ip_account_id = p_party_account_tbl(l_count).ip_account_id
2584: AND acct.instance_party_id = pty.instance_party_id;
2585:
2586: l_acct_row := l_acct_row+1;

Line 2659: from CSI_I_PARTIES

2655: l_object_id := null;
2656: Begin
2657: select instance_id
2658: into l_object_id
2659: from CSI_I_PARTIES
2660: where instance_party_id = l_party_account_tbl(l_old_party_row).instance_party_id
2661: and relationship_type_code = 'OWNER'
2662: and (active_end_date IS NULL OR active_end_date > sysdate);
2663: Exception

Line 2708: csi_i_parties pty

2704: INTO l_party_account_tbl(l_old_party_row).ip_account_id,
2705: l_party_account_tbl(l_old_party_row).object_version_number,
2706: l_party_id
2707: FROM csi_ip_accounts acct,
2708: csi_i_parties pty
2709: WHERE pty.instance_party_id = acct.instance_party_id
2710: AND pty.instance_id = l_rel_tbl(j).subject_id
2711: AND acct.relationship_type_code = 'OWNER'
2712: AND (acct.active_end_date IS NULL OR