APPS.OKS_MASS_UPDATE_PVT dependencies on HZ_CUST_ACCOUNTS

Line 15: --| HZ_CUST_ACCOUNTS | X | | | | | |

11: --| OKC_OPER_INST_PVT | | | | | |X |
12: --+---------------------------------+---+---+---+---+---+----------------------+
13: --| OKS_STREAM_LEVELS_V | X | | | | | |
14: --+---------------------------------+---+---+---+---+---+----------------------+
15: --| HZ_CUST_ACCOUNTS | X | | | | | |
16: --+---------------------------------+---+---+---+---+---+----------------------+
17: --| MTL_SYSTEM_ITEMS_TL | X | | | | | |
18: --+---------------------------------+---+---+---+---+---+----------------------+
19: --| MTL_SYSTEM_ITEMS_B_KFV | X | | | | | |

Line 880: FROM hz_cust_accounts

876: IS
877: CURSOR l_party_csr
878: IS
879: SELECT party_id
880: FROM hz_cust_accounts
881: WHERE cust_account_id = p_cust_id;
882: BEGIN
883: OPEN l_party_csr;
884:

Line 1310: FROM hz_cust_accounts ca1,

1306: SELECT 'x'
1307: FROM DUAL
1308: WHERE p_acct_id IN (
1309: SELECT ca1.cust_account_id id1
1310: FROM hz_cust_accounts ca1,
1311: hz_parties party
1312: WHERE ca1.party_id = p_party_id
1313: AND ca1.party_id = party.party_id
1314: AND ca1.status = 'A'

Line 1317: FROM hz_cust_accounts ca2,

1313: AND ca1.party_id = party.party_id
1314: AND ca1.status = 'A'
1315: UNION
1316: SELECT ca2.cust_account_id id1
1317: FROM hz_cust_accounts ca2,
1318: hz_parties party1
1319: WHERE ca2.party_id = party1.party_id
1320: AND ca2.cust_account_id IN (
1321: SELECT a.related_cust_account_id

Line 1323: hz_cust_accounts b

1319: WHERE ca2.party_id = party1.party_id
1320: AND ca2.cust_account_id IN (
1321: SELECT a.related_cust_account_id
1322: FROM hz_cust_acct_relate_all a,
1323: hz_cust_accounts b
1324: WHERE b.cust_account_id = a.cust_account_id
1325: AND b.party_id = p_party_id
1326: AND b.status = 'A'
1327: AND a.status = 'A'

Line 1525: FROM hz_cust_accounts acct

1521: IS
1522: SELECT 'x'
1523: FROM hz_parties party
1524: WHERE EXISTS (SELECT 'x'
1525: FROM hz_cust_accounts acct
1526: WHERE party.party_id = acct.party_id
1527: AND acct.status = 'A')
1528: AND party.party_id = p_party_id;
1529: BEGIN

Line 1671: From HZ_CUST_ACCOUNTS CA1

1667: IS
1668: l_dummy_var VARCHAR2 (3);
1669: Cursor Check_Acct_Csr Is
1670: SELECT 'Y'
1671: From HZ_CUST_ACCOUNTS CA1
1672: , HZ_PARTIES party
1673: WHERE CA1.party_id = P_party_id
1674: And CA1. cust_account_id = p_account_id
1675: And CA1.party_id = party.party_id

Line 1681: FROM HZ_CUST_ACCOUNTS CA2

1677:
1678: UNION
1679:
1680: SELECT 'Y'
1681: FROM HZ_CUST_ACCOUNTS CA2
1682: , HZ_CUST_ACCT_RELATE_ALL A
1683: , HZ_CUST_ACCOUNTS B
1684: WHERE CA2.cust_account_id = A.RELATED_CUST_ACCOUNT_ID
1685: And B.CUST_ACCOUNT_ID = A.CUST_ACCOUNT_ID

Line 1683: , HZ_CUST_ACCOUNTS B

1679:
1680: SELECT 'Y'
1681: FROM HZ_CUST_ACCOUNTS CA2
1682: , HZ_CUST_ACCT_RELATE_ALL A
1683: , HZ_CUST_ACCOUNTS B
1684: WHERE CA2.cust_account_id = A.RELATED_CUST_ACCOUNT_ID
1685: And B.CUST_ACCOUNT_ID = A.CUST_ACCOUNT_ID
1686: And Ca2.cust_account_id = p_account_id
1687: And B.party_id = p_party_id and B.status = 'A'

Line 6502: hz_cust_accounts c,

6498: d.party_name party_name,
6499: a.batch_id batch_id
6500: FROM oks_batch_rules a,
6501: oks_billing_profiles_b b,
6502: hz_cust_accounts c,
6503: hz_parties d
6504: WHERE a.batch_id = p_batch_id
6505: AND b.ID(+) = a.billing_profile_id
6506: AND c.cust_account_id = NVL(a.new_account_id, p_new_acct_id)

Line 6542: hz_cust_accounts b1,

6538: CURSOR check_relation_csr
6539: IS
6540: SELECT DISTINCT a.relationship_type
6541: FROM hz_relationships a,
6542: hz_cust_accounts b1,
6543: hz_cust_accounts b2,
6544: oks_instance_temp c
6545: WHERE ( ( a.object_id = b1.party_id
6546: AND a.subject_id = b2.party_id

Line 6543: hz_cust_accounts b2,

6539: IS
6540: SELECT DISTINCT a.relationship_type
6541: FROM hz_relationships a,
6542: hz_cust_accounts b1,
6543: hz_cust_accounts b2,
6544: oks_instance_temp c
6545: WHERE ( ( a.object_id = b1.party_id
6546: AND a.subject_id = b2.party_id
6547: )