APPS.CSI_T_VLDN_ROUTINES_PVT dependencies on CSI_I_PARTIES

Line 462: /* validate instance party id from csi_i_parties */

458: x_return_status := fnd_api.g_ret_sts_error;
459:
460: END validate_ii_rltns_type_code;
461:
462: /* validate instance party id from csi_i_parties */
463: PROCEDURE validate_instance_party_id(
464: p_instance_id IN number,
465: p_instance_party_id IN number,
466: x_return_status OUT NOCOPY VARCHAR2)

Line 473: FROM csi_i_parties

469: BEGIN
470:
471: SELECT 'X'
472: INTO v_found
473: FROM csi_i_parties
474: WHERE instance_id = p_instance_id
475: AND instance_party_id = p_instance_party_id;
476:
477: x_return_status := fnd_api.g_ret_sts_success;

Line 1233: FROM csi_i_parties

1229: l_csi_instance_id csi_t_party_details.instance_party_id%TYPE;
1230:
1231: CURSOR csi_pty_cur(p_csi_instance_id IN NUMBER) IS
1232: SELECT instance_party_id
1233: FROM csi_i_parties
1234: WHERE instance_id = p_csi_instance_id
1235: AND relationship_type_code = 'OWNER';
1236:
1237: BEGIN