APPS.JL_BR_AR_BANK_ACCT_PKG dependencies on JL_REV_TMP

Line 1012: from jl_rev_tmp) tmp,

1008: lag(distribution_id,1,to_number(NULL)) over (partition by document_id, distribution_type
1009: order by occurrence_id) lagdist,
1010: lag(distribution_id,1,to_number(NULL)) over (partition by document_id, occurrence_id, distribution_type
1011: order by accounting_reversal_option) cancellagdist
1012: from jl_rev_tmp) tmp,
1013: jl_br_ar_distributns_all dist
1014: where tmp.distribution_id = dist.distribution_id
1015: and (tmp.ACCOUNTING_REVERSAL_OPTION = 'Y'
1016: or dist.std_occurrence_code in ('FULL_SETTLEMENT', 'PARTIAL_SETTLEMENT')

Line 1091: into jl_rev_tmp (

1087: )
1088: WHEN STD_OCCURRENCE_CODE IN ('REMITTANCE', 'FULL_SETTLEMENT', 'PARTIAL_SETTLEMENT',
1089: 'REJECTED_ENTRY', 'WRITE_OFF_REQUISITION', 'AUTOMATIC_WRITE_OFF')
1090: THEN
1091: into jl_rev_tmp (
1092: distribution_id, document_id, occurrence_id, distribution_type, ACCOUNTING_REVERSAL_OPTION
1093: )
1094: values (
1095: jl_br_ar_distributns_s.NEXTVAL, document_id, occurrence_id, distribution_type, ACCOUNTING_REVERSAL_OPTION