APPS.JL_BR_AR_LOG_VALIDATION dependencies on JL_BR_AR_BANK_OCCURRENCES

Line 31: X_bank_occurrence_code_std jl_br_ar_bank_occurrences.std_occurrence_code%TYPE;

27: X_cgc jl_br_ar_ret_interface_all.inscription_number%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;

Line 88: FROM jl_br_ar_bank_occurrences occ,

84: BEGIN
85: -- CE uptake - Bug#2932986
86: SELECT occ.std_occurrence_code
87: INTO X_bank_occurrence_code_std
88: FROM jl_br_ar_bank_occurrences occ,
89: hz_organization_profiles prof
90: WHERE occ.bank_occurrence_code = X_bank_occurrence_code
91: AND prof.bank_or_branch_number = X_bank_number
92: AND occ.bank_party_id = prof.party_id

Line 122: FROM jl_br_ar_bank_occurrences

118: BEGIN
119: /* CE uptake - Bug#2932986
120: SELECT distinct bank_number
121: INTO X_jlbr_bank_number
122: FROM jl_br_ar_bank_occurrences
123: WHERE bank_number = X_bank_number
124: AND ROWNUM < 2;
125: */
126:

Line 131: FROM jl_br_ar_bank_occurrences occ,

127: SELECT prof.bank_or_branch_number,
128: occ.bank_party_id
129: INTO X_jlbr_bank_number,
130: p_bank_party_id
131: FROM jl_br_ar_bank_occurrences occ,
132: hz_organization_profiles prof
133: WHERE prof.bank_or_branch_number = X_bank_number
134: AND occ.bank_party_id = prof.party_id
135: AND prof.home_country ='BR'

Line 577: FROM jl_br_ar_bank_occurrences ban,

573:
574: BEGIN
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'