APPS.JL_BR_AR_LOG_VALIDATION dependencies on JL_BR_AR_COLLECTION_DOCS

Line 32: X_document_status jl_br_ar_collection_docs_all.document_status%TYPE;

28: X_bank_occurrence_code jl_br_ar_ret_interface_all.bank_occurrence_code%TYPE;
29: X_company_use jl_br_ar_ret_interface_all.company_use%TYPE;
30: X_your_number jl_br_ar_ret_interface_all.your_number%TYPE;
31: X_bank_occurrence_code_std jl_br_ar_bank_occurrences.std_occurrence_code%TYPE;
32: X_document_status jl_br_ar_collection_docs_all.document_status%TYPE;
33: X_customer_name jl_br_ar_ret_interface_all.customer_name%TYPE;
34: X_payment_schedule_id jl_br_ar_collection_docs_all.payment_schedule_id%TYPE;
35: X_trade_note_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;
36: X_document_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;

Line 34: X_payment_schedule_id jl_br_ar_collection_docs_all.payment_schedule_id%TYPE;

30: X_your_number jl_br_ar_ret_interface_all.your_number%TYPE;
31: X_bank_occurrence_code_std jl_br_ar_bank_occurrences.std_occurrence_code%TYPE;
32: X_document_status jl_br_ar_collection_docs_all.document_status%TYPE;
33: X_customer_name jl_br_ar_ret_interface_all.customer_name%TYPE;
34: X_payment_schedule_id jl_br_ar_collection_docs_all.payment_schedule_id%TYPE;
35: X_trade_note_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;
36: X_document_amount jl_br_ar_ret_interface_all.trade_note_amount%TYPE;
37: X_credit_amount jl_br_ar_ret_interface_all.credit_amount%TYPE;
38: X_interest_amount_received jl_br_ar_ret_interface_all.interest_amount_received%TYPE;

Line 153: jl_br_ar_collection_docs cd,

149: /*
150: SELECT distinct aba.global_attribute7
151: INTO X_dual_num
152: FROM ap_bank_accounts_all aba,
153: jl_br_ar_collection_docs cd,
154: ar_payment_schedules_all arps
155: WHERE cd.document_id = X_company_use
156: AND aba.bank_account_id = cd.bank_account_id
157: AND arps.payment_schedule_id = cd.payment_schedule_id

Line 167: jl_br_ar_collection_docs cd,

163: SELECT distinct acct.secondary_account_reference
164: INTO X_dual_num
165: FROM ce_bank_accounts acct,
166: ce_bank_acct_uses_all acctUse,
167: jl_br_ar_collection_docs cd,
168: ar_payment_schedules_all arps
169: WHERE cd.document_id = X_company_use
170: AND acctUse.bank_acct_use_id = cd.bank_acct_use_id
171: AND acct.bank_account_id = acctUse.bank_account_id

Line 199: FROM jl_br_ar_collection_docs doc,

195: bra.bank_number
196: INTO X_payment_schedule_id,
197: X_document_status,
198: X_remittance_bank
199: FROM jl_br_ar_collection_docs doc,
200: ap_bank_accounts_all acc,
201: ap_bank_branches bra
202: WHERE doc.document_id = X_company_use
203: AND doc.bank_account_id = acc.bank_account_id

Line 213: FROM jl_br_ar_collection_docs doc,

209: HzPartyBank.party_id bank_id
210: INTO X_payment_schedule_id,
211: X_document_status,
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

Line 269: FROM jl_br_ar_collection_docs doc,

265: SELECT doc.document_status,
266: bra.bank_number
267: INTO X_document_status,
268: X_remittance_bank
269: FROM jl_br_ar_collection_docs doc,
270: ap_bank_accounts_all acc,
271: ap_bank_branches bra
272: WHERE doc.payment_schedule_id = X_payment_schedule_id
273: AND doc.bank_account_id = acc.bank_account_id

Line 579: jl_br_ar_collection_docs cob

575: SELECT nvl(doc.document_amount,0)
576: INTO X_document_amount
577: FROM jl_br_ar_bank_occurrences ban,
578: jl_br_ar_occurrence_docs_all doc,
579: jl_br_ar_collection_docs cob
580: WHERE ban.std_occurrence_code = 'REMITTANCE'
581: AND ban.bank_occurrence_type = 'REMITTANCE_OCCURRENCE'
582: --AND ban.bank_number = X_bank_number
583: AND ban.bank_party_id = p_bank_party_id