APPS.CSI_ORDER_FULFILL_PUB dependencies on CSI_I_PARTIES

Line 2720: FROM csi_i_parties

2716: BEGIN
2717: IF l_pty_dtl_tbl(l_p_ind).relationship_type_code = 'OWNER' THEN
2718: SELECT instance_party_id
2719: INTO l_pty_dtl_tbl(l_pc_ind).contact_party_id
2720: FROM csi_i_parties
2721: WHERE instance_id = l_u_instance_rec.instance_id
2722: AND relationship_type_code = l_pty_dtl_tbl(l_p_ind).relationship_type_code
2723: AND ((active_end_date is null ) OR
2724: (active_end_date > sysdate));

Line 2728: FROM csi_i_parties

2724: (active_end_date > sysdate));
2725: ELSE
2726: SELECT instance_party_id
2727: INTO l_pty_dtl_tbl(l_pc_ind).contact_party_id
2728: FROM csi_i_parties
2729: WHERE instance_id = l_u_instance_rec.instance_id
2730: AND party_id = l_pty_dtl_tbl(l_p_ind).party_source_id -- old party
2731: AND party_source_table = l_pty_dtl_tbl(l_p_ind).party_source_table
2732: AND nvl(contact_flag,'N') = nvl(l_pty_dtl_tbl(l_p_ind).contact_flag,'N')

Line 2807: FROM csi_i_parties

2803: SELECT instance_party_id,
2804: object_version_number
2805: INTO l_instance_party_id,
2806: l_pty_object_ver_num
2807: FROM csi_i_parties
2808: WHERE instance_id = p_instance_id
2809: AND relationship_type_code = 'OWNER';
2810:
2811: l_u_party_tbl(1).instance_party_id := l_instance_party_id;

Line 8102: l_td_owner_type csi_i_parties.party_source_table%TYPE;

8098:
8099: l_time_stamp date;
8100:
8101: l_td_owner_id number;
8102: l_td_owner_type csi_i_parties.party_source_table%TYPE;
8103: l_inst_owner_id number;
8104: l_inst_owner_type csi_i_parties.party_source_table%TYPE;
8105: l_internal_party_id number;
8106: l_ownership_override varchar2(1) := 'N';

Line 8104: l_inst_owner_type csi_i_parties.party_source_table%TYPE;

8100:
8101: l_td_owner_id number;
8102: l_td_owner_type csi_i_parties.party_source_table%TYPE;
8103: l_inst_owner_id number;
8104: l_inst_owner_type csi_i_parties.party_source_table%TYPE;
8105: l_internal_party_id number;
8106: l_ownership_override varchar2(1) := 'N';
8107: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
8108: l_msg_data varchar2(2000);

Line 11377: FROM csi_i_parties

11373:
11374: BEGIN
11375: SELECT object_version_number
11376: INTO p_party_tbl(1).object_version_number
11377: FROM csi_i_parties
11378: WHERE instance_party_id = l_inst_party_id;
11379: END;
11380:
11381: p_party_account_tbl(1).parent_tbl_index := 1;