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.CSC_PROFILE_ENGINE_PKG dependencies on HZ_CUST_ACCOUNTS

Line 651: FROM hz_cust_accounts hz

647: SELECT party_id,
648: cust_account_id,
649: NULL, -- Added 'NULL' for party_site_id by spamujul for ER#8473903
650: NULL
651: FROM hz_cust_accounts hz
652: WHERE NOT EXISTS (SELECT 1
653: FROM CSC_PROF_BATCH_RESULTS1_T c
654: WHERE c.account_id = hz.cust_account_id
655: AND C.PARTY_SITE_ID IS NULL -- Added by spamujul for ER#8473903

Line 1025: FROM hz_cust_accounts

1021: -- Person, ORG added for 1850508
1022:
1023: CURSOR caccount_csr IS
1024: SELECT party_id, cust_account_id
1025: FROM hz_cust_accounts
1026: WHERE party_id=v_party_id
1027: AND status = 'A' ;
1028: -- Begin fix by spamujul for NCR ER#8473903
1029: CURSOR cpsite_csr IS

Line 1482: FROM hz_cust_accounts

1478:
1479: /* added this condition party_id=v_party_id for Bug 1937730*/
1480: CURSOR caccount_csr IS
1481: SELECT party_id, cust_account_id
1482: FROM hz_cust_accounts
1483: WHERE party_id=v_party_id
1484: AND status = 'A';
1485: -- Begin fix by spamujul for ER#8473903
1486: CURSOR cpsite_csr IS

Line 1991: FROM hz_cust_accounts

1987: /* added this condition party_id=v_party_id for Bug 1937730*/
1988: CURSOR caccount_csr IS
1989: SELECT party_id,
1990: cust_account_id
1991: FROM hz_cust_accounts
1992: WHERE party_id=v_party_id
1993: AND status = 'A' ;
1994: -- Begin fix by spamujul for ER#8473903
1995: CURSOR cpsite_csr IS

Line 2808: FROM hz_cust_accounts

2804:
2805: /* added this condition party_id=v_party_id for Bug 1937730*/
2806: CURSOR caccount_csr IS
2807: SELECT party_id, cust_account_id
2808: FROM hz_cust_accounts
2809: WHERE party_id=v_party_id
2810: AND status = 'A' ;
2811: -- Begin fix by spamujul for ER#8473903
2812: CURSOR cpsite_csr IS

Line 3882: FROM hz_cust_accounts hz

3878: ACCOUNT_ID,
3879: PARTY_SITE_ID, --Included party_site_id for ER#8473903
3880: VALUE)
3881: SELECT party_id, cust_account_id, NULL ,NULL -- Included NULL for party_site_id for ER#8473903
3882: FROM hz_cust_accounts hz
3883: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.account_id = hz.cust_account_id)
3884: AND hz.status = 'A';
3885: ELSIF v_check_level = 'EMPLOYEE' THEN
3886: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,PARTY_SITE_ID,VALUE) --Included party_site_id for ER#8473903

Line 4248: FROM hz_cust_accounts

4244: -- Person, ORG added for 1850508
4245:
4246: CURSOR caccount_csr IS
4247: SELECT party_id, cust_account_id
4248: FROM hz_cust_accounts
4249: WHERE party_id=v_party_id
4250: AND status = 'A' ;
4251: -- Begin fix by spamujul for NCR ER#8473903
4252: CURSOR cpsite_csr IS

Line 4694: FROM hz_cust_accounts

4690: -- Person, ORG added for 1850508
4691: /* added this condition party_id=v_party_id for Bug 1937730*/
4692: CURSOR caccount_csr IS
4693: SELECT party_id, cust_account_id
4694: FROM hz_cust_accounts
4695: WHERE party_id=v_party_id
4696: AND status = 'A' ;
4697: -- Begin fix by spamujul for ER#8473903
4698: CURSOR cpsite_csr IS

Line 5846: FROM hz_cust_accounts

5842: -- cursor to update all results of an account
5843: /* added this condition party_id=v_party_id for Bug 1937730*/
5844: CURSOR baccount_csr IS
5845: SELECT party_id, cust_account_id
5846: FROM hz_cust_accounts
5847: WHERE party_id=v_party_id
5848: AND status = 'A' ;
5849:
5850: -- Begin fix by spamujul for NCR ER#8473903

Line 6142: FROM hz_cust_accounts

6138:
6139: -- cursor to update all results of an account
6140: CURSOR baccount_csr IS
6141: SELECT party_id, cust_account_id
6142: FROM hz_cust_accounts
6143: WHERE party_id=v_party_id
6144: AND status = 'A' ;
6145:
6146: -- Begin fx by spamujul for ER#8473903

Line 6413: FROM hz_cust_accounts

6409: -- cursor to update all results of an account
6410: /* added this condition party_id=v_party_id for Bug 1937730*/
6411: CURSOR baccount_csr IS
6412: SELECT party_id, cust_account_id
6413: FROM hz_cust_accounts
6414: WHERE party_id=v_party_id
6415: AND status = 'A' ;
6416: -- Begin fix by spamujul for NCR ER#8473903
6417: CURSOR bpsite_csr IS

Line 6735: FROM hz_cust_accounts

6731: /* added this condition party_id=v_party_id for Bug 1937730*/
6732: -- cursor to update all results of an account
6733: CURSOR baccount_csr IS
6734: SELECT party_id, cust_account_id
6735: FROM hz_cust_accounts
6736: WHERE party_id=v_party_id
6737: AND status = 'A' ;
6738: -- added for 1850508
6739: -- Begin fix by spamujul for ER#8473903

Line 7022: FROM hz_cust_accounts

7018:
7019: -- cursor to update all results of an account
7020: CURSOR baccount_csr IS
7021: SELECT party_id, cust_account_id
7022: FROM hz_cust_accounts
7023: WHERE party_id=v_party_id
7024: AND status = 'A' ;
7025: -- Begin fx by spamujul for ER#8473903
7026: CURSOR bpsite_csr IS

Line 9613: FROM hz_cust_accounts

9609: WHERE party_id = l_party_id;
9610:
9611: CURSOR get_acct_latest IS
9612: SELECT cust_account_id
9613: FROM hz_cust_accounts
9614: WHERE party_id = l_party_id
9615: AND ((status = 'A' AND l_show_active_acct = 'Y')
9616: OR (l_show_active_acct = 'N'))
9617: AND status NOT IN ('M', 'D')

Line 9622: FROM hz_cust_accounts

9618: ORDER BY creation_date DESC;
9619:
9620: CURSOR get_acct_oldest IS
9621: SELECT cust_account_id
9622: FROM hz_cust_accounts
9623: WHERE party_id = l_party_id
9624: AND ((status = 'A' AND l_show_active_acct = 'Y')
9625: OR (l_show_active_acct = 'N'))
9626: AND status NOT IN ('M', 'D')

Line 9746: FROM hz_cust_accounts

9742: );
9743: BEGIN
9744: SELECT cust_account_id
9745: INTO l_acct_id
9746: FROM hz_cust_accounts
9747: WHERE party_id = l_party_id
9748: AND ((status = 'A' AND l_show_active_acct = 'Y') OR (l_show_active_acct = 'N'))
9749: AND status NOT IN ('M', 'D');
9750: EXCEPTION

Line 9889: FROM hz_cust_accounts

9885: );
9886: BEGIN
9887: SELECT cust_account_id
9888: INTO l_acct_id
9889: FROM hz_cust_accounts
9890: WHERE party_id = l_party_id
9891: AND ((status = 'A' AND l_show_active_acct = 'Y') OR (l_show_active_acct = 'N'))
9892: AND status NOT IN ('M', 'D');
9893: EXCEPTION

Line 10088: FROM hz_cust_accounts

10084: );
10085: BEGIN
10086: SELECT cust_account_id
10087: INTO l_acct_id
10088: FROM hz_cust_accounts
10089: WHERE party_id = l_party_id
10090: AND ((status = 'A' AND l_show_active_acct = 'Y') OR (l_show_active_acct = 'N'))
10091: AND status NOT IN ('M', 'D');
10092: EXCEPTION