APPS.CSI_MASS_EDIT_PUB dependencies on CSI_T_PARTY_DETAILS

Line 241: ,csi_t_party_details cid

237: ,cil.install_location_type_code install_location_type_code
238: ,cid.party_source_id party_id
239: ,cid.party_source_table party_source_table
240: FROM csi_t_txn_line_details cil
241: ,csi_t_party_details cid
242: WHERE cil.transaction_line_id = p_txn_line_id
243: AND cil.instance_id = p_instance_id
244: AND cid.txn_line_detail_id = cil.txn_line_detail_id
245: AND cid.relationship_type_code = 'OWNER';

Line 1338: FROM CSI_T_PARTY_DETAILS WHERE TXN_LINE_DETAIL_ID IN(

1334: Debug_out('System Cascade :' || l_system_cascade);
1335:
1336: BEGIN
1337: SELECT 'x' INTO l_new_owner
1338: FROM CSI_T_PARTY_DETAILS WHERE TXN_LINE_DETAIL_ID IN(
1339: SELECT TXN_LINE_DETAIL_ID FROM CSI_T_TXN_LINE_DETAILS CTLD, CSI_MASS_EDIT_ENTRIES_VL CMEE
1340: WHERE CTLD.TRANSACTION_LINE_ID = CMEE.TXN_LINE_ID
1341: AND CMEE.ENTRY_ID = p_entry_id
1342: AND INSTANCE_ID IS NULL)

Line 1348: FROM CSI_T_PARTY_DETAILS WHERE TXN_LINE_DETAIL_ID IN(

1344: AND RELATIONSHIP_TYPE_CODE = 'OWNER'
1345: AND ROWNUM = 1;
1346:
1347: SELECT 'x' INTO l_old_owner
1348: FROM CSI_T_PARTY_DETAILS WHERE TXN_LINE_DETAIL_ID IN(
1349: SELECT TXN_LINE_DETAIL_ID FROM CSI_T_TXN_LINE_DETAILS CTLD, CSI_MASS_EDIT_ENTRIES_VL CMEE
1350: WHERE CTLD.TRANSACTION_LINE_ID = CMEE.TXN_LINE_ID
1351: AND CMEE.ENTRY_ID = p_entry_id
1352: AND INSTANCE_ID IS NOT NULL)

Line 2255: csi_t_party_details tp,

2251: tp.party_source_id PartyId,
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

Line 2724: FROM CSI_T_PARTY_DETAILS TP,

2720:
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