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 1311: hz_parties party

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

Line 1318: hz_parties party1

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

Line 1523: FROM hz_parties party

1519:
1520: CURSOR l_party_csr
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')

Line 1579: hz_parties p3,

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

Line 1580: hz_parties p2,

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

Line 1672: , HZ_PARTIES party

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

Line 6503: hz_parties d

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