APPS.CSI_INSTANCE_PARTIES_VLD_PVT dependencies on CSI_IP_ACCOUNTS_H_S

Line 708: FROM csi_ip_accounts_h s,

704: FETCH C2 into l_account_temp;
705: IF C2%FOUND then
706: SELECT MAX(t.source_transaction_date) -- Changed from Transaction_date to Source_transaction_date
707: INTO l_transaction_date
708: FROM csi_ip_accounts_h s,
709: csi_transactions t
710: WHERE s.ip_account_id =l_account_temp
711: AND s.transaction_id=t.transaction_id
712: AND t.transaction_id <> nvl(p_txn_id, -99999);

Line 1311: FROM csi_ip_accounts_h s,

1307:
1308: IF p_end_date < sysdate THEN
1309: SELECT MAX(t.source_transaction_date) -- Changed from Transaction_date to Source_transaction_date
1310: INTO l_transaction_date
1311: FROM csi_ip_accounts_h s,
1312: csi_transactions t
1313: WHERE s.ip_account_id=p_ip_account_id
1314: AND s.transaction_id=t.transaction_id
1315: AND t.transaction_id <> nvl(p_txn_id, -99999);

Line 1376: SELECT CSI_IP_ACCOUNTS_H_S.nextval

1372: FUNCTION gen_ip_account_hist_id
1373: RETURN NUMBER IS
1374: l_ip_account_hist_id NUMBER;
1375: BEGIN
1376: SELECT CSI_IP_ACCOUNTS_H_S.nextval
1377: INTO l_ip_account_hist_id
1378: FROM sys.dual;
1379: RETURN l_ip_account_hist_id ;
1380: END gen_ip_account_hist_id;