APPS.CSI_ITEM_INSTANCE_PUB dependencies on CSI_I_PARTIES

Line 731: FROM csi_i_parties cip

727: --
728: BEGIN
729: SELECT cip.party_id
730: INTO l_party_id
731: FROM csi_i_parties cip
732: WHERE cip.instance_id = p_instance_rec.instance_id
733: AND cip.relationship_type_code = 'OWNER';
734: EXCEPTION
735: WHEN OTHERS THEN

Line 1622: FROM csi_i_parties cip

1618:
1619: BEGIN
1620: SELECT cip.party_id
1621: INTO l_owner_party_id
1622: FROM csi_i_parties cip
1623: WHERE cip.instance_id = p_instance_rec.instance_id
1624: AND cip.relationship_type_code = 'OWNER';
1625: EXCEPTION
1626: WHEN OTHERS THEN

Line 1698: FROM csi_i_parties

1694: l_cascade_party_tbl(1).relationship_type_code,
1695: l_cascade_party_tbl(1).contact_flag,
1696: l_cascade_party_tbl(1).object_version_number,
1697: l_cascade_party_tbl(1).cascade_ownership_flag
1698: FROM csi_i_parties
1699: WHERE instance_id=p_instance_rec.instance_id
1700: AND relationship_type_code='OWNER'
1701: AND (active_end_date IS NULL OR active_end_date>sysdate);
1702:

Line 2172: FROM csi_i_parties

2168: BEGIN
2169: l_tem_party_id:=NULL;
2170: SELECT party_id
2171: INTO l_tem_party_id
2172: FROM csi_i_parties
2173: WHERE instance_party_id=lc_party_tbl(i).instance_party_id
2174: AND relationship_type_code='OWNER';
2175: EXCEPTION
2176: WHEN OTHERS THEN

Line 2210: FROM csi_i_parties

2206: -- THEN
2207: BEGIN
2208: SELECT active_end_date
2209: INTO l_bump_date --lc_party_tbl(k).active_end_date
2210: FROM csi_i_parties
2211: WHERE instance_party_id=lc_party_tbl(k).instance_party_id;
2212:
2213: -- Added the following if condition for bug 3376233.
2214: IF l_bump_date IS NULL OR

Line 3017: FROM csi_i_parties cip

3013: --
3014: BEGIN
3015: SELECT cip.party_id
3016: INTO l_party_id
3017: FROM csi_i_parties cip
3018: WHERE cip.instance_id = p_instance_rec.instance_id
3019: AND cip.relationship_type_code = 'OWNER';
3020: EXCEPTION
3021: WHEN OTHERS THEN