APPS.JL_BR_AR_LOG_VALIDATION dependencies on HZ_PARTIES

Line 62: l_party_id hz_parties.party_id%TYPE;

58: l_acct_balancing_segment ar_system_parameters.global_attribute1%TYPE;
59: l_ledger_info xle_businessinfo_grp.le_ledger_rec_type;
60: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;
61: l_legal_entity_name xle_entity_profiles.name%TYPE;
62: l_party_id hz_parties.party_id%TYPE;
63: l_party_type hz_parties.party_type%TYPE;
64:
65: BEGIN
66:

Line 63: l_party_type hz_parties.party_type%TYPE;

59: l_ledger_info xle_businessinfo_grp.le_ledger_rec_type;
60: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;
61: l_legal_entity_name xle_entity_profiles.name%TYPE;
62: l_party_id hz_parties.party_id%TYPE;
63: l_party_type hz_parties.party_type%TYPE;
64:
65: BEGIN
66:
67: X_bank_number := p_bank_number;

Line 216: hz_parties HzPartyBank

212: X_remittance_bank_id
213: FROM jl_br_ar_collection_docs doc,
214: ce_bank_accounts CeBankAccount,
215: ce_bank_acct_uses_all CeBankAcctUse,
216: hz_parties HzPartyBank
217: Where doc.bank_acct_use_id = CeBankAcctUse.bank_acct_use_id
218: And CeBankAcctUse.bank_account_id = CeBankAccount.bank_account_id
219: And CeBankAccount.BANK_ID = HzPartyBank.PARTY_ID
220: --And HzPartyBank.Country = 'BR'

Line 524: hz_parties pty,

520: BEGIN
521: SELECT substr(pty.party_name, 1,50)
522: INTO X_customer_name1
523: FROM hz_cust_accounts_all cst,
524: hz_parties pty,
525: ra_customer_trx trx
526: WHERE trx.bill_to_customer_id = cst.cust_account_id
527: AND cst.party_id = pty.party_id
528: AND trx.customer_trx_id = (SELECT customer_trx_id