APPS.CSI_ITEM_INSTANCE_PUB dependencies on CSI_I_PARTIES

Line 732: FROM csi_i_parties cip

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

Line 1526: FROM csi_i_parties

1522: IF p_party_tbl.EXISTS(l_party_rec) THEN
1523: csi_gen_utility_pvt.put_line('p_party_tbl(l_party_rec).instance_party_id = '||p_party_tbl(l_party_rec).instance_party_id);
1524: SELECT instance_id
1525: INTO l_inst_id
1526: FROM csi_i_parties
1527: WHERE instance_party_id = p_party_tbl(l_party_rec).instance_party_id
1528: AND ROWNUM = 1;
1529: END IF;
1530: END LOOP;

Line 1689: FROM csi_i_parties cip

1685:
1686: BEGIN
1687: SELECT cip.party_id
1688: INTO l_owner_party_id
1689: FROM csi_i_parties cip
1690: WHERE cip.instance_id = p_instance_rec.instance_id
1691: AND cip.relationship_type_code = 'OWNER';
1692: EXCEPTION
1693: WHEN OTHERS THEN

Line 1780: FROM csi_i_parties

1776: l_cascade_party_tbl(1).relationship_type_code,
1777: l_cascade_party_tbl(1).contact_flag,
1778: l_cascade_party_tbl(1).object_version_number,
1779: l_cascade_party_tbl(1).cascade_ownership_flag
1780: FROM csi_i_parties
1781: WHERE instance_id=p_instance_rec.instance_id
1782: AND relationship_type_code='OWNER'
1783: AND (active_end_date IS NULL OR active_end_date>sysdate);
1784:

Line 2255: FROM csi_i_parties

2251: BEGIN
2252: l_tem_party_id:=NULL;
2253: SELECT party_id
2254: INTO l_tem_party_id
2255: FROM csi_i_parties
2256: WHERE instance_party_id=lc_party_tbl(i).instance_party_id
2257: AND relationship_type_code='OWNER';
2258: EXCEPTION
2259: WHEN OTHERS THEN

Line 2293: FROM csi_i_parties

2289: -- THEN
2290: BEGIN
2291: SELECT active_end_date
2292: INTO l_bump_date --lc_party_tbl(k).active_end_date
2293: FROM csi_i_parties
2294: WHERE instance_party_id=lc_party_tbl(k).instance_party_id;
2295:
2296: -- Added the following if condition for bug 3376233.
2297: IF l_bump_date IS NULL OR

Line 3100: FROM csi_i_parties cip

3096: --
3097: BEGIN
3098: SELECT cip.party_id
3099: INTO l_party_id
3100: FROM csi_i_parties cip
3101: WHERE cip.instance_id = p_instance_rec.instance_id
3102: AND cip.relationship_type_code = 'OWNER';
3103: EXCEPTION
3104: WHEN OTHERS THEN