APPS.LNS_PARTICIPANTS_PUB dependencies on HZ_PARTIES

Line 80: hz_parties party,

76: -- validation for bill_to_site_use
77: CURSOR c_site_uses(p_primary_borrower_id NUMBER, p_cust_account_id NUMBER, p_bill_to_acct_site_id number) IS
78: select 'Y' valid_acct_site_party
79: from
80: hz_parties party,
81: hz_party_sites site,
82: hz_cust_accounts acct,
83: hz_cust_acct_sites acct_site,
84: hz_cust_site_uses acc_site_use

Line 185: P_TABLE_NAME => 'HZ_PARTIES');

181: X_MSG_DATA => l_msg_data,
182: X_RETURN_STATUS => l_return_status,
183: P_COL_ID => l_hz_party_id,
184: P_COL_NAME => 'PARTY_ID',
185: P_TABLE_NAME => 'HZ_PARTIES');
186: --dbms_output.put_line('output2');
187:
188: if l_return_status <> FND_API.G_RET_STS_SUCCESS then
189: FND_MESSAGE.SET_NAME('LNS', 'LNS_INVALID_VALUE');

Line 392: from hz_parties

388: and prod.loan_product_id = loan.product_id;
389:
390: CURSOR c_get_party_type(p_party_id number) IS
391: select party_type
392: from hz_parties
393: where party_id = p_party_id;
394:
395: l_last_api_called varchar2(500); --Store the last api that was called before exception
396: l_api_name CONSTANT VARCHAR2(30) := 'createParticipant';

Line 1642: from hz_parties

1638: l_api_name CONSTANT varchar2(25) := 'getDefaultPrimaryContact';
1639:
1640: CURSOR c_get_party_type(p_party_id number) IS
1641: select party_type
1642: from hz_parties
1643: where party_id = p_party_id;
1644:
1645: BEGIN
1646: