APPS.JL_BR_AR_LOG_VALIDATION dependencies on JL_BR_AR_COLLECTION_DOCS

Line 34: X_document_status jl_br_ar_collection_docs_all.document_status%TYPE;

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

Line 36: X_payment_schedule_id jl_br_ar_collection_docs_all.payment_schedule_id%TYPE;

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

Line 251: jl_br_ar_collection_docs cd,

247: /*
248: SELECT distinct aba.global_attribute7
249: INTO X_dual_num
250: FROM ap_bank_accounts_all aba,
251: jl_br_ar_collection_docs cd,
252: ar_payment_schedules_all arps
253: WHERE cd.document_id = X_company_use
254: AND aba.bank_account_id = cd.bank_account_id
255: AND arps.payment_schedule_id = cd.payment_schedule_id

Line 265: jl_br_ar_collection_docs cd,

261: SELECT distinct acct.secondary_account_reference
262: INTO X_dual_num
263: FROM ce_bank_accounts acct,
264: ce_bank_acct_uses_all acctUse,
265: jl_br_ar_collection_docs cd,
266: ar_payment_schedules_all arps
267: WHERE cd.document_id = X_company_use
268: AND acctUse.bank_acct_use_id = cd.bank_acct_use_id
269: AND acct.bank_account_id = acctUse.bank_account_id

Line 301: FROM jl_br_ar_collection_docs doc,

297: bra.bank_number
298: INTO X_payment_schedule_id,
299: X_document_status,
300: X_remittance_bank
301: FROM jl_br_ar_collection_docs doc,
302: ap_bank_accounts_all acc,
303: ap_bank_branches bra
304: WHERE doc.document_id = X_company_use
305: AND doc.bank_account_id = acc.bank_account_id

Line 315: FROM jl_br_ar_collection_docs doc,

311: HzPartyBank.party_id bank_id
312: INTO X_payment_schedule_id,
313: X_document_status,
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

Line 377: FROM jl_br_ar_collection_docs doc,

373: SELECT doc.document_status,
374: bra.bank_number
375: INTO X_document_status,
376: X_remittance_bank
377: FROM jl_br_ar_collection_docs doc,
378: ap_bank_accounts_all acc,
379: ap_bank_branches bra
380: WHERE doc.payment_schedule_id = X_payment_schedule_id
381: AND doc.bank_account_id = acc.bank_account_id

Line 729: jl_br_ar_collection_docs cob

725: SELECT nvl(doc.document_amount,0)
726: INTO X_document_amount
727: FROM jl_br_ar_bank_occurrences ban,
728: jl_br_ar_occurrence_docs_all doc,
729: jl_br_ar_collection_docs cob
730: WHERE ban.std_occurrence_code = 'REMITTANCE'
731: AND ban.bank_occurrence_type = 'REMITTANCE_OCCURRENCE'
732: --AND ban.bank_number = X_bank_number
733: AND ban.bank_party_id = p_bank_party_id