eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CSI_INSTANCE_PARTIES_VLD_PVT dependencies on CSI_IP_ACCOUNTS

Line 658: FROM csi_ip_accounts

654: AND ((active_end_date is null) or (active_end_date > sysdate));
655:
656: CURSOR C2 is
657: SELECT ip_account_id
658: FROM csi_ip_accounts
659: WHERE instance_party_id = p_instance_party_id
660: AND ((active_end_date is null) or (active_end_date > sysdate));
661:
662: BEGIN

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 840: /* exists in csi_ip_accounts */

836:
837: /*-----------------------------------------------------------*/
838: /* Procedure name: Is_Pty_Acct_Comb_Exists */
839: /* Description : Check if the party account combination */
840: /* exists in csi_ip_accounts */
841: /*-----------------------------------------------------------*/
842:
843: FUNCTION Is_Pty_Acct_Comb_Exists
844: (

Line 858: FROM csi_ip_accounts

854: BEGIN
855:
856: SELECT 'x'
857: INTO l_dummy
858: FROM csi_ip_accounts
859: WHERE instance_party_id = p_instance_party_id
860: and party_account_id = p_party_account_id
861: and relationship_type_code = p_relationship_type
862: and ((active_end_date is null) OR (trunc(active_end_date,'MI') >= trunc(sysdate,'MI'))); --Changed to trunc for bug 9750206

Line 879: /* exists in csi_ip_accounts */

875:
876: /*-----------------------------------------------------------*/
877: /* Procedure name: Is_IP_account_Exists */
878: /* Description : Check if the IP_account_id */
879: /* exists in csi_ip_accounts */
880: /*-----------------------------------------------------------*/
881:
882: FUNCTION Is_IP_account_Exists
883: ( p_ip_account_id IN NUMBER,

Line 891: FROM csi_ip_accounts

887: l_return_value BOOLEAN := TRUE;
888: BEGIN
889: SELECT 'x'
890: INTO l_dummy
891: FROM csi_ip_accounts
892: WHERE ip_account_id = p_ip_account_id
893: and ((active_end_date is null) OR (trunc(active_end_date,'MI') >= trunc(sysdate,'MI'))); --Changed to trunc for bug 9750206
894: IF ( p_stack_err_msg = TRUE ) THEN
895: FND_MESSAGE.SET_NAME('CSI','CSI_API_IP_ACCOUNT_ID');

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 1360: SELECT CSI_IP_ACCOUNTS_S.nextval

1356: RETURN NUMBER IS
1357: l_ip_account_id NUMBER;
1358: BEGIN
1359:
1360: SELECT CSI_IP_ACCOUNTS_S.nextval
1361: INTO l_ip_account_id
1362: FROM sys.dual;
1363: RETURN l_ip_account_id ;
1364: END gen_ip_account_id;

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;

Line 1712: FROM csi_ip_accounts

1708: l_return_value BOOLEAN := TRUE;
1709: BEGIN
1710: SELECT 'x'
1711: INTO l_dummy
1712: FROM csi_ip_accounts
1713: WHERE ip_account_id = p_ip_account_id;
1714: RETURN l_return_value;
1715: EXCEPTION
1716: WHEN NO_DATA_FOUND THEN

Line 1724: /* exists in csi_ip_accounts */

1720:
1721: /*-----------------------------------------------------------*/
1722: /* Procedure name: Is_IP_account_Valid */
1723: /* Description : Check if the IP_account_id */
1724: /* exists in csi_ip_accounts */
1725: /*-----------------------------------------------------------*/
1726:
1727: FUNCTION Is_IP_account_Valid
1728: ( p_ip_account_id IN NUMBER,

Line 1736: FROM csi_ip_accounts

1732: l_return_value BOOLEAN := TRUE;
1733: BEGIN
1734: SELECT 'x'
1735: INTO l_dummy
1736: FROM csi_ip_accounts
1737: WHERE ip_account_id = p_ip_account_id
1738: and ((active_end_date is null) OR (active_end_date >= sysdate));
1739: RETURN l_return_value;
1740: EXCEPTION

Line 1832: FROM csi_ip_accounts

1828: BEGIN
1829:
1830: SELECT 'x'
1831: INTO l_dummy
1832: FROM csi_ip_accounts
1833: WHERE instance_party_id = p_instance_party_id
1834: and relationship_type_code = p_relationship_type
1835: and ((active_end_date is null) OR (active_end_date > sysdate));
1836: IF ( p_stack_err_msg = TRUE ) THEN

Line 2030: FROM csi_ip_accounts

2026: BEGIN
2027:
2028: SELECT 'x'
2029: INTO l_dummy
2030: FROM csi_ip_accounts
2031: WHERE instance_party_id = p_party_account_rec.instance_party_id
2032: AND party_account_id = p_party_account_rec.party_account_id
2033: AND relationship_type_code = p_party_account_rec.relationship_type_code
2034: AND active_start_date = p_party_account_rec.active_start_date

Line 2238: FROM csi_ip_accounts

2234: SELECT ip_account_id,
2235: relationship_type_code, -- Added by sguthiva for bug 2307804
2236: party_account_id, -- Added by sguthiva for bug 2307804
2237: object_version_number
2238: FROM csi_ip_accounts
2239: WHERE instance_party_id = i_inst_party_id
2240: AND (( ACTIVE_END_DATE IS NULL) OR (ACTIVE_END_DATE >= SYSDATE)) ;
2241:
2242: BEGIN