APPS.OKS_MASS_UPDATE_PVT dependencies on HZ_PARTIES

Line 35: --| HZ_PARTIES | X | | | | | |

31: --| JTF_NOTES_PUB | | | | | |X |
32: --+---------------------------------+---+---+---+---+---+----------------------+
33: --| JTF_NOTES_VL | X | | | | | |
34: --+---------------------------------+---+---+---+---+---+----------------------+
35: --| HZ_PARTIES | X | | | | | |
36: --+---------------------------------+---+---+---+---+---+----------------------+
37: --| HZ_CUST_ACCT_RELATE_ALL | X | | | | | |
38: --+---------------------------------+---+---+---+---+---+----------------------+
39: --| DUAL | X | | | | | |

Line 1307: hz_parties party

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'
1311: UNION

Line 1314: hz_parties party1

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
1318: FROM hz_cust_acct_relate_all a,

Line 1519: FROM hz_parties party

1515:
1516: CURSOR l_party_csr
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')

Line 1575: hz_parties p3,

1571: CURSOR l_cust_ctc_csr
1572: IS
1573: SELECT 'x'
1574: FROM hz_relationships r,
1575: hz_parties p3,
1576: hz_parties p2,
1577: hz_org_contacts oc
1578: WHERE p2.party_id = r.subject_id
1579: AND r.relationship_code IN ('CONTACT_OF', 'EMPLOYEE_OF')

Line 1576: hz_parties p2,

1572: IS
1573: SELECT 'x'
1574: FROM hz_relationships r,
1575: hz_parties p3,
1576: hz_parties p2,
1577: hz_org_contacts oc
1578: WHERE p2.party_id = r.subject_id
1579: AND r.relationship_code IN ('CONTACT_OF', 'EMPLOYEE_OF')
1580: AND r.content_source_type = 'USER_ENTERED'

Line 1668: , HZ_PARTIES party

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
1672: And CA1.status = 'A'

Line 6486: hz_parties d

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)
6490: AND c.party_id = d.party_id;