APPS.CSI_PROCESS_TXN_PVT dependencies on CSI_I_PARTIES

Line 2142: FROM csi_i_parties

2138: SELECT instance_party_id ,
2139: object_version_number
2140: INTO p_parties_tbl(l_ind).instance_party_id,
2141: p_parties_tbl(l_ind).object_version_number
2142: FROM csi_i_parties
2143: WHERE instance_id = p_instance_rec.instance_id
2144: AND relationship_type_code = 'OWNER'
2145: AND sysdate BETWEEN nvl(active_start_date, sysdate-1)
2146: AND nvl(active_end_date, sysdate+1);

Line 2267: FROM csi_i_parties

2263: SELECT instance_party_id,
2264: object_version_number,
2265: party_id,
2266: relationship_type_code
2267: FROM csi_i_parties
2268: WHERE instance_id = p_instance_rec.instance_id
2269: AND relationship_type_code <> 'OWNER'
2270: AND contact_flag = 'N'
2271: AND sysdate BETWEEN nvl(active_start_date, sysdate-1)

Line 2353: FROM csi_i_parties

2349: SELECT instance_party_id,
2350: object_version_number
2351: INTO l_instance_party_id,
2352: l_object_version_number
2353: FROM csi_i_parties
2354: WHERE instance_id = p_instance_id
2355: AND relationship_type_code = 'OWNER';
2356:
2357: p_parties_tbl(1).instance_party_id := l_instance_party_id;

Line 3344: FROM csi_i_parties

3340: SELECT instance_party_id ,
3341: object_version_number
3342: INTO l_u_parties_tbl(l_up_ind).instance_party_id,
3343: l_u_parties_tbl(l_up_ind).object_version_number
3344: FROM csi_i_parties
3345: WHERE instance_id = l_u_instance_rec.instance_id
3346: AND relationship_type_code =
3347: l_u_parties_tbl(l_up_ind).relationship_type_code;
3348: EXCEPTION