APPS.CSI_ORDER_FULFILL_PUB dependencies on CSI_I_PARTIES

Line 2680: FROM csi_i_parties

2676: BEGIN
2677: IF l_pty_dtl_tbl(l_p_ind).relationship_type_code = 'OWNER' THEN
2678: SELECT instance_party_id
2679: INTO l_pty_dtl_tbl(l_pc_ind).contact_party_id
2680: FROM csi_i_parties
2681: WHERE instance_id = l_u_instance_rec.instance_id
2682: AND relationship_type_code = l_pty_dtl_tbl(l_p_ind).relationship_type_code
2683: AND ((active_end_date is null ) OR
2684: (active_end_date > sysdate));

Line 2688: FROM csi_i_parties

2684: (active_end_date > sysdate));
2685: ELSE
2686: SELECT instance_party_id
2687: INTO l_pty_dtl_tbl(l_pc_ind).contact_party_id
2688: FROM csi_i_parties
2689: WHERE instance_id = l_u_instance_rec.instance_id
2690: AND party_id = l_pty_dtl_tbl(l_p_ind).party_source_id -- old party
2691: AND party_source_table = l_pty_dtl_tbl(l_p_ind).party_source_table
2692: AND nvl(contact_flag,'N') = nvl(l_pty_dtl_tbl(l_p_ind).contact_flag,'N')

Line 2767: FROM csi_i_parties

2763: SELECT instance_party_id,
2764: object_version_number
2765: INTO l_instance_party_id,
2766: l_pty_object_ver_num
2767: FROM csi_i_parties
2768: WHERE instance_id = p_instance_id
2769: AND relationship_type_code = 'OWNER';
2770:
2771: l_u_party_tbl(1).instance_party_id := l_instance_party_id;

Line 7305: l_td_owner_type csi_i_parties.party_source_table%TYPE;

7301:
7302: l_time_stamp date;
7303:
7304: l_td_owner_id number;
7305: l_td_owner_type csi_i_parties.party_source_table%TYPE;
7306: l_inst_owner_id number;
7307: l_inst_owner_type csi_i_parties.party_source_table%TYPE;
7308: l_internal_party_id number;
7309: l_ownership_override varchar2(1) := 'N';

Line 7307: l_inst_owner_type csi_i_parties.party_source_table%TYPE;

7303:
7304: l_td_owner_id number;
7305: l_td_owner_type csi_i_parties.party_source_table%TYPE;
7306: l_inst_owner_id number;
7307: l_inst_owner_type csi_i_parties.party_source_table%TYPE;
7308: l_internal_party_id number;
7309: l_ownership_override varchar2(1) := 'N';
7310: l_return_status varchar2(1) := fnd_api.g_ret_sts_success;
7311: l_msg_data varchar2(2000);

Line 10361: FROM csi_i_parties

10357:
10358: BEGIN
10359: SELECT object_version_number
10360: INTO p_party_tbl(1).object_version_number
10361: FROM csi_i_parties
10362: WHERE instance_party_id = l_inst_party_id;
10363: END;
10364:
10365: p_party_account_tbl(1).parent_tbl_index := 1;