APPS.CSI_MASS_EDIT_PUB dependencies on CSI_T_PARTY_DETAILS

Line 245: ,csi_t_party_details cid

241: ,cil.install_location_type_code install_location_type_code
242: ,cid.party_source_id party_id
243: ,cid.party_source_table party_source_table
244: FROM csi_t_txn_line_details cil
245: ,csi_t_party_details cid
246: WHERE cil.transaction_line_id = p_txn_line_id
247: AND cil.instance_id = p_instance_id
248: AND cid.txn_line_detail_id = cil.txn_line_detail_id
249: AND cid.relationship_type_code = 'OWNER';

Line 1452: FROM CSI_T_PARTY_DETAILS WHERE TXN_LINE_DETAIL_ID IN(

1448: Debug_out('System Cascade :' || l_system_cascade);
1449:
1450: BEGIN
1451: SELECT 'x' INTO l_new_owner
1452: FROM CSI_T_PARTY_DETAILS WHERE TXN_LINE_DETAIL_ID IN(
1453: SELECT TXN_LINE_DETAIL_ID FROM CSI_T_TXN_LINE_DETAILS CTLD, CSI_MASS_EDIT_ENTRIES_VL CMEE
1454: WHERE CTLD.TRANSACTION_LINE_ID = CMEE.TXN_LINE_ID
1455: AND CMEE.ENTRY_ID = p_entry_id
1456: AND INSTANCE_ID IS NULL)

Line 1462: FROM CSI_T_PARTY_DETAILS WHERE TXN_LINE_DETAIL_ID IN(

1458: AND RELATIONSHIP_TYPE_CODE = 'OWNER'
1459: AND ROWNUM = 1;
1460:
1461: SELECT 'x' INTO l_old_owner
1462: FROM CSI_T_PARTY_DETAILS WHERE TXN_LINE_DETAIL_ID IN(
1463: SELECT TXN_LINE_DETAIL_ID FROM CSI_T_TXN_LINE_DETAILS CTLD, CSI_MASS_EDIT_ENTRIES_VL CMEE
1464: WHERE CTLD.TRANSACTION_LINE_ID = CMEE.TXN_LINE_ID
1465: AND CMEE.ENTRY_ID = p_entry_id
1466: AND INSTANCE_ID IS NOT NULL)

Line 2370: csi_t_party_details tp,

2366: tp.party_source_id PartyId,
2367: ta.account_id AccountId,
2368: party.party_number PartyNumber
2369: FROM csi_t_txn_line_details tld,
2370: csi_t_party_details tp,
2371: csi_t_party_accounts ta,
2372: hz_parties party,
2373: hz_cust_accounts account
2374: WHERE tld.txn_line_detail_id = tp.txn_line_detail_id

Line 2839: FROM CSI_T_PARTY_DETAILS TP,

2835:
2836: CURSOR SYS_ACCOUNT_CSR (p_entry_id IN NUMBER) IS
2837: SELECT TA.ACCOUNT_ID ACCOUNT_ID,
2838: TP.PARTY_SOURCE_ID PARTY_ID
2839: FROM CSI_T_PARTY_DETAILS TP,
2840: CSI_T_PARTY_ACCOUNTS TA ,
2841: CSI_T_TXN_LINE_DETAILS CTLD ,
2842: CSI_MASS_EDIT_ENTRIES_VL CMEE
2843: WHERE CMEE.ENTRY_ID = p_entry_id