APPS.CSI_PROCESS_TXN_PVT dependencies on CSI_I_PARTIES

Line 1880: FROM csi_i_parties

1876: SELECT instance_party_id ,
1877: object_version_number
1878: INTO p_parties_tbl(l_ind).instance_party_id,
1879: p_parties_tbl(l_ind).object_version_number
1880: FROM csi_i_parties
1881: WHERE instance_id = p_instance_rec.instance_id
1882: AND relationship_type_code = 'OWNER'
1883: AND sysdate BETWEEN nvl(active_start_date, sysdate-1)
1884: AND nvl(active_end_date, sysdate+1);

Line 2005: FROM csi_i_parties

2001: SELECT instance_party_id,
2002: object_version_number,
2003: party_id,
2004: relationship_type_code
2005: FROM csi_i_parties
2006: WHERE instance_id = p_instance_rec.instance_id
2007: AND relationship_type_code <> 'OWNER'
2008: AND contact_flag = 'N'
2009: AND sysdate BETWEEN nvl(active_start_date, sysdate-1)

Line 2091: FROM csi_i_parties

2087: SELECT instance_party_id,
2088: object_version_number
2089: INTO l_instance_party_id,
2090: l_object_version_number
2091: FROM csi_i_parties
2092: WHERE instance_id = p_instance_id
2093: AND relationship_type_code = 'OWNER';
2094:
2095: p_parties_tbl(1).instance_party_id := l_instance_party_id;

Line 3074: FROM csi_i_parties

3070: SELECT instance_party_id ,
3071: object_version_number
3072: INTO l_u_parties_tbl(l_up_ind).instance_party_id,
3073: l_u_parties_tbl(l_up_ind).object_version_number
3074: FROM csi_i_parties
3075: WHERE instance_id = l_u_instance_rec.instance_id
3076: AND relationship_type_code =
3077: l_u_parties_tbl(l_up_ind).relationship_type_code;
3078: EXCEPTION