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 876: FROM hz_cust_accounts

872: IS
873: CURSOR l_party_csr
874: IS
875: SELECT party_id
876: FROM hz_cust_accounts
877: WHERE cust_account_id = p_cust_id;
878: BEGIN
879: OPEN l_party_csr;
880:

Line 1306: FROM hz_cust_accounts ca1,

1302: SELECT 'x'
1303: FROM DUAL
1304: WHERE p_acct_id IN (
1305: SELECT ca1.cust_account_id id1
1306: FROM hz_cust_accounts ca1,
1307: hz_parties party
1308: WHERE ca1.party_id = p_party_id
1309: AND ca1.party_id = party.party_id
1310: AND ca1.status = 'A'

Line 1313: FROM hz_cust_accounts ca2,

1309: AND ca1.party_id = party.party_id
1310: AND ca1.status = 'A'
1311: UNION
1312: SELECT ca2.cust_account_id id1
1313: FROM hz_cust_accounts ca2,
1314: hz_parties party1
1315: WHERE ca2.party_id = party1.party_id
1316: AND ca2.cust_account_id IN (
1317: SELECT a.related_cust_account_id

Line 1319: hz_cust_accounts b

1315: WHERE ca2.party_id = party1.party_id
1316: AND ca2.cust_account_id IN (
1317: SELECT a.related_cust_account_id
1318: FROM hz_cust_acct_relate_all a,
1319: hz_cust_accounts b
1320: WHERE b.cust_account_id = a.cust_account_id
1321: AND b.party_id = p_party_id
1322: AND b.status = 'A'
1323: AND a.status = 'A'

Line 1521: FROM hz_cust_accounts acct

1517: IS
1518: SELECT 'x'
1519: FROM hz_parties party
1520: WHERE EXISTS (SELECT 'x'
1521: FROM hz_cust_accounts acct
1522: WHERE party.party_id = acct.party_id
1523: AND acct.status = 'A')
1524: AND party.party_id = p_party_id;
1525: BEGIN

Line 1667: From HZ_CUST_ACCOUNTS CA1

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

Line 1677: FROM HZ_CUST_ACCOUNTS CA2

1673:
1674: UNION
1675:
1676: SELECT 'Y'
1677: FROM HZ_CUST_ACCOUNTS CA2
1678: , HZ_CUST_ACCT_RELATE_ALL A
1679: , HZ_CUST_ACCOUNTS B
1680: WHERE CA2.cust_account_id = A.RELATED_CUST_ACCOUNT_ID
1681: And B.CUST_ACCOUNT_ID = A.CUST_ACCOUNT_ID

Line 1679: , HZ_CUST_ACCOUNTS B

1675:
1676: SELECT 'Y'
1677: FROM HZ_CUST_ACCOUNTS CA2
1678: , HZ_CUST_ACCT_RELATE_ALL A
1679: , HZ_CUST_ACCOUNTS B
1680: WHERE CA2.cust_account_id = A.RELATED_CUST_ACCOUNT_ID
1681: And B.CUST_ACCOUNT_ID = A.CUST_ACCOUNT_ID
1682: And Ca2.cust_account_id = p_account_id
1683: And B.party_id = p_party_id and B.status = 'A'

Line 6485: hz_cust_accounts c,

6481: d.party_name party_name,
6482: a.batch_id batch_id
6483: FROM oks_batch_rules a,
6484: oks_billing_profiles_b b,
6485: hz_cust_accounts c,
6486: hz_parties d
6487: WHERE a.batch_id = p_batch_id
6488: AND b.ID(+) = a.billing_profile_id
6489: AND c.cust_account_id = NVL(a.new_account_id, p_new_acct_id)

Line 6525: hz_cust_accounts b1,

6521: CURSOR check_relation_csr
6522: IS
6523: SELECT DISTINCT a.relationship_type
6524: FROM hz_relationships a,
6525: hz_cust_accounts b1,
6526: hz_cust_accounts b2,
6527: oks_instance_temp c
6528: WHERE ( ( a.object_id = b1.party_id
6529: AND a.subject_id = b2.party_id

Line 6526: hz_cust_accounts b2,

6522: IS
6523: SELECT DISTINCT a.relationship_type
6524: FROM hz_relationships a,
6525: hz_cust_accounts b1,
6526: hz_cust_accounts b2,
6527: oks_instance_temp c
6528: WHERE ( ( a.object_id = b1.party_id
6529: AND a.subject_id = b2.party_id
6530: )