APPS.CSI_UTL_PKG dependencies on CSI_I_PARTIES

Line 68: FROM csi_i_parties

64: api_log('get_curr_party');
65:
66: SELECT party_id
67: INTO l_inst_pty_id
68: FROM csi_i_parties
69: WHERE instance_id = p_instance_id
70: AND relationship_type_code = p_rel_type_code
71: AND ((active_end_date is null ) OR (active_end_date > sysdate));
72:

Line 284: FROM csi_i_parties

280: SELECT object_version_number,
281: instance_party_id
282: INTO x_obj_version_number,
283: x_inst_pty_qty
284: FROM csi_i_parties
285: WHERE instance_id = p_instance_id
286: AND relationship_type_code = p_rel_type_code
287: AND ((active_end_date is null ) OR
288: (active_end_date > sysdate));

Line 374: FROM csi_i_parties

370: api_log('get_pty_obj_ver_num');
371:
372: SELECT object_version_number
373: INTO l_obj_ver_num
374: FROM csi_i_parties
375: WHERE instance_party_id = p_inst_pty_id
376: AND ((active_end_date is null ) OR
377: (active_end_date > sysdate));
378: RETURN l_obj_ver_num;

Line 1252: FROM csi_i_parties

1248: api_log('validate_inst_party');
1249:
1250: SELECT 'x'
1251: INTO l_dummy
1252: FROM csi_i_parties
1253: WHERE instance_id = p_instance_id
1254: AND instance_party_id = p_inst_party_id
1255: AND relationship_type_code = p_pty_rel_code
1256: AND ((active_end_date is null ) OR

Line 1334: FROM csi_i_parties

1330: api_log('get_instance_party_id');
1331:
1332: SELECT instance_party_id
1333: INTO l_inst_party_id
1334: FROM csi_i_parties
1335: WHERE instance_id = p_instance_id
1336: AND relationship_type_code = 'OWNER'
1337: AND ((active_end_date is null)
1338: OR

Line 2478: FROM csi_i_parties

2474: SELECT instance_party_id,
2475: object_version_number
2476: INTO x_i_party_rec.instance_party_id,
2477: x_i_party_rec.object_version_number
2478: FROM csi_i_parties
2479: WHERE instance_id = p_instance_id
2480: AND party_id = x_i_party_rec.party_id
2481: AND relationship_type_code = x_i_party_rec.relationship_type_code
2482: AND contact_flag = x_i_party_rec.contact_flag;

Line 2491: FROM csi_i_parties

2487: /*null check added-bug 6455823*/
2488: ELSIF Nvl(p_t_party_rec.instance_party_id, fnd_api.g_miss_num) <> fnd_api.g_miss_num THEN
2489: SELECT object_version_number
2490: INTO x_i_party_rec.object_version_number
2491: FROM csi_i_parties
2492: WHERE instance_party_id = p_t_party_rec.instance_party_id;
2493: END IF;
2494: END convert_tpty_to_ipty;
2495:

Line 2592: FROM csi_i_parties

2588:
2589: BEGIN
2590: SELECT instance_party_id
2591: INTO l_owner_inst_pty_id
2592: FROM csi_i_parties
2593: WHERE instance_id = p_instance_id
2594: AND relationship_type_code = 'OWNER';
2595: EXCEPTION
2596: WHEN no_data_found THEN

Line 2738: FROM csi_i_parties

2734: SELECT instance_party_id,
2735: object_version_number
2736: INTO l_pty_rec.instance_party_id,
2737: l_pty_rec.object_version_number
2738: FROM csi_i_parties
2739: WHERE instance_id = p_instance_id
2740: AND party_id = l_pty_rec.party_id
2741: AND relationship_type_code = l_pty_rec.relationship_type_code
2742: AND contact_flag = 'Y';

Line 2789: FROM csi_i_parties

2785: SELECT instance_party_id,
2786: object_version_number
2787: INTO l_pty_rec.instance_party_id,
2788: l_pty_rec.object_version_number
2789: FROM csi_i_parties
2790: WHERE instance_id = p_instance_id
2791: AND party_id = l_pty_rec.party_id
2792: AND relationship_type_code = l_pty_rec.relationship_type_code
2793: AND contact_flag = 'Y';

Line 4269: From csi_i_parties

4265: Select instance_party_id,
4266: object_version_number
4267: Into l_upd_party_tbl(1).instance_party_id,
4268: l_upd_party_tbl(1).object_version_number
4269: From csi_i_parties
4270: Where instance_id = l_old_instance_id
4271: And relationship_Type_code = 'OWNER';
4272:
4273: EXCEPTION

Line 5170: FROM csi_i_parties

5166: object_version_number
5167: INTO x_upd_party_tbl(i).instance_id,
5168: x_upd_party_tbl(i).instance_party_id,
5169: x_upd_party_tbl(i).object_version_number
5170: FROM csi_i_parties
5171: WHERE instance_id = l_instance_id
5172: AND relationship_type_code = 'OWNER'
5173: AND (sysdate > nvl(active_start_date, sysdate -1)
5174: OR