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 656: FROM csi_ip_accounts

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

Line 706: FROM csi_ip_accounts_h s,

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

Line 838: /* exists in csi_ip_accounts */

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

Line 856: FROM csi_ip_accounts

852: BEGIN
853:
854: SELECT 'x'
855: INTO l_dummy
856: FROM csi_ip_accounts
857: WHERE instance_party_id = p_instance_party_id
858: and party_account_id = p_party_account_id
859: and relationship_type_code = p_relationship_type
860: and ((active_end_date is null) OR (active_end_date >= sysdate));

Line 877: /* exists in csi_ip_accounts */

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

Line 889: FROM csi_ip_accounts

885: l_return_value BOOLEAN := TRUE;
886: BEGIN
887: SELECT 'x'
888: INTO l_dummy
889: FROM csi_ip_accounts
890: WHERE ip_account_id = p_ip_account_id
891: and ((active_end_date is null) OR (active_end_date >= sysdate));
892: IF ( p_stack_err_msg = TRUE ) THEN
893: FND_MESSAGE.SET_NAME('CSI','CSI_API_IP_ACCOUNT_ID');

Line 1307: FROM csi_ip_accounts_h s,

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

Line 1356: SELECT CSI_IP_ACCOUNTS_S.nextval

1352: RETURN NUMBER IS
1353: l_ip_account_id NUMBER;
1354: BEGIN
1355:
1356: SELECT CSI_IP_ACCOUNTS_S.nextval
1357: INTO l_ip_account_id
1358: FROM sys.dual;
1359: RETURN l_ip_account_id ;
1360: END gen_ip_account_id;

Line 1372: SELECT CSI_IP_ACCOUNTS_H_S.nextval

1368: FUNCTION gen_ip_account_hist_id
1369: RETURN NUMBER IS
1370: l_ip_account_hist_id NUMBER;
1371: BEGIN
1372: SELECT CSI_IP_ACCOUNTS_H_S.nextval
1373: INTO l_ip_account_hist_id
1374: FROM sys.dual;
1375: RETURN l_ip_account_hist_id ;
1376: END gen_ip_account_hist_id;

Line 1708: FROM csi_ip_accounts

1704: l_return_value BOOLEAN := TRUE;
1705: BEGIN
1706: SELECT 'x'
1707: INTO l_dummy
1708: FROM csi_ip_accounts
1709: WHERE ip_account_id = p_ip_account_id;
1710: RETURN l_return_value;
1711: EXCEPTION
1712: WHEN NO_DATA_FOUND THEN

Line 1720: /* exists in csi_ip_accounts */

1716:
1717: /*-----------------------------------------------------------*/
1718: /* Procedure name: Is_IP_account_Valid */
1719: /* Description : Check if the IP_account_id */
1720: /* exists in csi_ip_accounts */
1721: /*-----------------------------------------------------------*/
1722:
1723: FUNCTION Is_IP_account_Valid
1724: ( p_ip_account_id IN NUMBER,

Line 1732: FROM csi_ip_accounts

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

Line 1828: FROM csi_ip_accounts

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

Line 2026: FROM csi_ip_accounts

2022: BEGIN
2023:
2024: SELECT 'x'
2025: INTO l_dummy
2026: FROM csi_ip_accounts
2027: WHERE instance_party_id = p_party_account_rec.instance_party_id
2028: AND party_account_id = p_party_account_rec.party_account_id
2029: AND relationship_type_code = p_party_account_rec.relationship_type_code
2030: AND active_start_date = p_party_account_rec.active_start_date

Line 2234: FROM csi_ip_accounts

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