APPS.CSC_PROFILE_ENGINE_PKG dependencies on HZ_CUST_ACCOUNTS

Line 583: FROM hz_cust_accounts hz

579: AND hz.party_type = 'PARTY_RELATIONSHIP';
580: ELSIF v_check_level = 'ACCOUNT' THEN
581: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)
582: SELECT party_id, cust_account_id, NULL
583: FROM hz_cust_accounts hz
584: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.account_id = hz.cust_account_id)
585: AND hz.status = 'A';
586: ELSIF v_check_level = 'EMPLOYEE' THEN
587: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)

Line 854: FROM hz_cust_accounts

850: -- Person, ORG added for 1850508
851:
852: CURSOR caccount_csr IS
853: SELECT party_id, cust_account_id
854: FROM hz_cust_accounts
855: WHERE party_id=v_party_id
856: AND status = 'A' ;
857:
858: CURSOR block_csr IS

Line 1164: FROM hz_cust_accounts

1160:
1161: /* added this condition party_id=v_party_id for Bug 1937730*/
1162: CURSOR caccount_csr IS
1163: SELECT party_id, cust_account_id
1164: FROM hz_cust_accounts
1165: WHERE party_id=v_party_id
1166: AND status = 'A';
1167:
1168: CURSOR block_csr IS

Line 1526: FROM hz_cust_accounts

1522:
1523: /* added this condition party_id=v_party_id for Bug 1937730*/
1524: CURSOR caccount_csr IS
1525: SELECT party_id, cust_account_id
1526: FROM hz_cust_accounts
1527: WHERE party_id=v_party_id
1528: AND status = 'A' ;
1529:
1530: BEGIN

Line 2088: FROM hz_cust_accounts

2084:
2085: /* added this condition party_id=v_party_id for Bug 1937730*/
2086: CURSOR caccount_csr IS
2087: SELECT party_id, cust_account_id
2088: FROM hz_cust_accounts
2089: WHERE party_id=v_party_id
2090: AND status = 'A' ;
2091:
2092: CURSOR checks_relparty_csr IS

Line 2766: FROM hz_cust_accounts hz

2762: AND hz.party_type = 'PARTY_RELATIONSHIP';
2763: ELSIF v_check_level = 'ACCOUNT' THEN
2764: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)
2765: SELECT party_id, cust_account_id, NULL
2766: FROM hz_cust_accounts hz
2767: WHERE NOT EXISTS (SELECT 1 FROM CSC_PROF_BATCH_RESULTS1_T c WHERE c.account_id = hz.cust_account_id)
2768: AND hz.status = 'A';
2769: ELSIF v_check_level = 'EMPLOYEE' THEN
2770: INSERT INTO CSC_PROF_BATCH_RESULTS1_T(PARTY_ID,ACCOUNT_ID,VALUE)

Line 3047: FROM hz_cust_accounts

3043: -- Person, ORG added for 1850508
3044:
3045: CURSOR caccount_csr IS
3046: SELECT party_id, cust_account_id
3047: FROM hz_cust_accounts
3048: WHERE party_id=v_party_id
3049: AND status = 'A' ;
3050:
3051: CURSOR block_csr IS

Line 3363: FROM hz_cust_accounts

3359:
3360: /* added this condition party_id=v_party_id for Bug 1937730*/
3361: CURSOR caccount_csr IS
3362: SELECT party_id, cust_account_id
3363: FROM hz_cust_accounts
3364: WHERE party_id=v_party_id
3365: AND status = 'A' ;
3366:
3367: CURSOR block_csr IS

Line 4244: FROM hz_cust_accounts

4240: -- cursor to update all results of an account
4241: /* added this condition party_id=v_party_id for Bug 1937730*/
4242: CURSOR baccount_csr IS
4243: SELECT party_id, cust_account_id
4244: FROM hz_cust_accounts
4245: WHERE party_id=v_party_id
4246: AND status = 'A' ;
4247:
4248: -- Added for 1850508

Line 4441: FROM hz_cust_accounts

4437:
4438: -- cursor to update all results of an account
4439: CURSOR baccount_csr IS
4440: SELECT party_id, cust_account_id
4441: FROM hz_cust_accounts
4442: WHERE party_id=v_party_id
4443: AND status = 'A' ;
4444:
4445: cid number;

Line 4616: FROM hz_cust_accounts

4612: -- cursor to update all results of an account
4613: /* added this condition party_id=v_party_id for Bug 1937730*/
4614: CURSOR baccount_csr IS
4615: SELECT party_id, cust_account_id
4616: FROM hz_cust_accounts
4617: WHERE party_id=v_party_id
4618: AND status = 'A' ;
4619:
4620:

Line 4810: FROM hz_cust_accounts

4806: /* added this condition party_id=v_party_id for Bug 1937730*/
4807: -- cursor to update all results of an account
4808: CURSOR baccount_csr IS
4809: SELECT party_id, cust_account_id
4810: FROM hz_cust_accounts
4811: WHERE party_id=v_party_id
4812: AND status = 'A' ;
4813:
4814: -- Added for 1850508

Line 5013: FROM hz_cust_accounts

5009:
5010: -- cursor to update all results of an account
5011: CURSOR baccount_csr IS
5012: SELECT party_id, cust_account_id
5013: FROM hz_cust_accounts
5014: WHERE party_id=v_party_id
5015: AND status = 'A' ;
5016:
5017: cid number;

Line 6880: FROM hz_cust_accounts

6876: WHERE party_id = l_party_id;
6877:
6878: CURSOR get_acct_latest IS
6879: SELECT cust_account_id
6880: FROM hz_cust_accounts
6881: WHERE party_id = l_party_id
6882: AND ((status = 'A' AND l_show_active_acct = 'Y')
6883: OR (l_show_active_acct = 'N'))
6884: AND status NOT IN ('M', 'D')

Line 6889: FROM hz_cust_accounts

6885: ORDER BY creation_date DESC;
6886:
6887: CURSOR get_acct_oldest IS
6888: SELECT cust_account_id
6889: FROM hz_cust_accounts
6890: WHERE party_id = l_party_id
6891: AND ((status = 'A' AND l_show_active_acct = 'Y')
6892: OR (l_show_active_acct = 'N'))
6893: AND status NOT IN ('M', 'D')

Line 7035: FROM hz_cust_accounts

7031: );
7032: BEGIN
7033: SELECT cust_account_id
7034: INTO l_acct_id
7035: FROM hz_cust_accounts
7036: WHERE party_id = l_party_id
7037: AND ((status = 'A' AND l_show_active_acct = 'Y') OR (l_show_active_acct = 'N'))
7038: AND status NOT IN ('M', 'D');
7039: EXCEPTION

Line 7181: FROM hz_cust_accounts

7177: );
7178: BEGIN
7179: SELECT cust_account_id
7180: INTO l_acct_id
7181: FROM hz_cust_accounts
7182: WHERE party_id = l_party_id
7183: AND ((status = 'A' AND l_show_active_acct = 'Y') OR (l_show_active_acct = 'N'))
7184: AND status NOT IN ('M', 'D');
7185: EXCEPTION

Line 7377: FROM hz_cust_accounts

7373: );
7374: BEGIN
7375: SELECT cust_account_id
7376: INTO l_acct_id
7377: FROM hz_cust_accounts
7378: WHERE party_id = l_party_id
7379: AND ((status = 'A' AND l_show_active_acct = 'Y') OR (l_show_active_acct = 'N'))
7380: AND status NOT IN ('M', 'D');
7381: EXCEPTION