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 2480: FROM csi_i_parties

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

Line 2493: FROM csi_i_parties

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

Line 2594: FROM csi_i_parties

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

Line 2778: FROM csi_i_parties

2774: SELECT instance_party_id,
2775: object_version_number
2776: INTO l_pty_rec.instance_party_id,
2777: l_pty_rec.object_version_number
2778: FROM csi_i_parties
2779: WHERE instance_id = p_instance_id
2780: AND party_id = l_pty_rec.party_id
2781: AND relationship_type_code = l_pty_rec.relationship_type_code
2782: AND contact_flag = 'Y';

Line 2830: FROM csi_i_parties

2826: SELECT instance_party_id,
2827: object_version_number
2828: INTO l_pty_rec.instance_party_id,
2829: l_pty_rec.object_version_number
2830: FROM csi_i_parties
2831: WHERE instance_id = p_instance_id
2832: AND party_id = l_pty_rec.party_id
2833: AND relationship_type_code = l_pty_rec.relationship_type_code
2834: AND contact_flag = 'Y';

Line 4311: From csi_i_parties

4307: Select instance_party_id,
4308: object_version_number
4309: Into l_upd_party_tbl(1).instance_party_id,
4310: l_upd_party_tbl(1).object_version_number
4311: From csi_i_parties
4312: Where instance_id = l_old_instance_id
4313: And relationship_Type_code = 'OWNER';
4314:
4315: EXCEPTION

Line 5216: FROM csi_i_parties

5212: object_version_number
5213: INTO x_upd_party_tbl(i).instance_id,
5214: x_upd_party_tbl(i).instance_party_id,
5215: x_upd_party_tbl(i).object_version_number
5216: FROM csi_i_parties
5217: WHERE instance_id = l_instance_id
5218: AND relationship_type_code = 'OWNER'
5219: AND (sysdate > nvl(active_start_date, sysdate -1)
5220: OR