APPS.JL_BR_AR_LOG_VALIDATION dependencies on HZ_PARTIES

Line 64: l_party_id hz_parties.party_id%TYPE;

60: l_acct_balancing_segment ar_system_parameters.global_attribute1%TYPE;
61: l_ledger_info xle_businessinfo_grp.le_ledger_rec_type;
62: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;
63: l_legal_entity_name xle_entity_profiles.name%TYPE;
64: l_party_id hz_parties.party_id%TYPE;
65: l_party_type hz_parties.party_type%TYPE;
66:
67:
68: -- Bug#8331293 Replaced SQL query with cursor

Line 65: l_party_type hz_parties.party_type%TYPE;

61: l_ledger_info xle_businessinfo_grp.le_ledger_rec_type;
62: l_legal_entity_id xle_entity_profiles.legal_entity_id%TYPE;
63: l_legal_entity_name xle_entity_profiles.name%TYPE;
64: l_party_id hz_parties.party_id%TYPE;
65: l_party_type hz_parties.party_type%TYPE;
66:
67:
68: -- Bug#8331293 Replaced SQL query with cursor
69: Cursor Comp_JLBRRVFD ( cp_ledger_id ar_system_parameters.set_of_books_id%TYPE

Line 318: hz_parties HzPartyBank

314: X_remittance_bank_id
315: FROM jl_br_ar_collection_docs doc,
316: ce_bank_accounts CeBankAccount,
317: ce_bank_acct_uses_all CeBankAcctUse,
318: hz_parties HzPartyBank
319: Where doc.bank_acct_use_id = CeBankAcctUse.bank_acct_use_id
320: And CeBankAcctUse.bank_account_id = CeBankAccount.bank_account_id
321: And CeBankAccount.BANK_ID = HzPartyBank.PARTY_ID
322: --And HzPartyBank.Country = 'BR'

Line 674: hz_parties pty,

670: BEGIN
671: SELECT substr(pty.party_name, 1,50)
672: INTO X_customer_name1
673: FROM hz_cust_accounts_all cst,
674: hz_parties pty,
675: ra_customer_trx trx
676: WHERE trx.bill_to_customer_id = cst.cust_account_id
677: AND cst.party_id = pty.party_id
678: AND trx.customer_trx_id = (SELECT customer_trx_id