APPS.CSI_T_TXN_LINE_DTLS_PVT dependencies on CSI_T_PARTY_DETAILS

Line 794: update csi_t_party_details

790: END LOOP;
791: END IF;
792:
793: IF l_contact_party_id is not null THEN
794: update csi_t_party_details
795: set contact_party_id = l_contact_party_id
796: where txn_party_detail_id = px_txn_party_dtl_tbl(cont_ind).txn_party_detail_id;
797: END IF;
798: END IF;

Line 979: FROM csi_t_party_details

975: l_pty_acc_ind binary_integer;
976:
977: CURSOR pty_cur (p_line_dtl_id in number) IS
978: SELECT *
979: FROM csi_t_party_details
980: WHERE txn_line_detail_id = p_line_dtl_id;
981:
982: l_iir_ids_tbl csi_t_datastructures_grp.txn_ii_rltns_ids_tbl;
983: l_oa_ids_tbl csi_t_datastructures_grp.txn_org_assgn_ids_tbl;

Line 1703: csi_t_party_details csitpd,

1699: INTO l_instance_party_id
1700: FROM
1701: csi_i_parties csiip,
1702: csi_i_parties csiipc,
1703: csi_t_party_details csitpd,
1704: csi_t_party_details csitpdc
1705: WHERE csitpdc.party_SOURCE_id = l_pty_cur_rec.party_source_id
1706: AND csiipc.instance_id=l_td_rec.instance_id
1707: AND csiip.contact_ip_id=csiipc.instance_party_id

Line 1704: csi_t_party_details csitpdc

1700: FROM
1701: csi_i_parties csiip,
1702: csi_i_parties csiipc,
1703: csi_t_party_details csitpd,
1704: csi_t_party_details csitpdc
1705: WHERE csitpdc.party_SOURCE_id = l_pty_cur_rec.party_source_id
1706: AND csiipc.instance_id=l_td_rec.instance_id
1707: AND csiip.contact_ip_id=csiipc.instance_party_id
1708: AND csitpdc.contact_party_id=csitpd.txn_party_detail_id

Line 2339: update csi_t_party_details

2335: END LOOP;
2336: END IF;
2337:
2338: IF l_contact_party_id is not null THEN
2339: update csi_t_party_details
2340: set contact_party_id = l_contact_party_id
2341: where txn_party_detail_id = l_c_pty_tbl(cont_ind).txn_party_detail_id;
2342: END IF;
2343: END IF;