2252: ta.account_id AccountId,
2253: party.party_number PartyNumber
2254: FROM csi_t_txn_line_details tld,
2255: csi_t_party_details tp,
2256: csi_t_party_accounts ta,
2257: hz_parties party,
2258: hz_cust_accounts account
2259: WHERE tld.txn_line_detail_id = tp.txn_line_detail_id
2260: AND tld.transaction_line_id = p_transaction_line_id
2721: CURSOR SYS_ACCOUNT_CSR (p_entry_id IN NUMBER) IS
2722: SELECT TA.ACCOUNT_ID ACCOUNT_ID,
2723: TP.PARTY_SOURCE_ID PARTY_ID
2724: FROM CSI_T_PARTY_DETAILS TP,
2725: CSI_T_PARTY_ACCOUNTS TA ,
2726: CSI_T_TXN_LINE_DETAILS CTLD ,
2727: CSI_MASS_EDIT_ENTRIES_VL CMEE
2728: WHERE CMEE.ENTRY_ID = p_entry_id
2729: AND TA.TXN_PARTY_DETAIL_ID = TP.TXN_PARTY_DETAIL_ID