APPS.JL_ZZ_AR_LIBRARY_1_PKG dependencies on JL_BR_AR_REC_MET_ACCTS_EXT

Line 52: -- Select amounts from jl_br_ar_rec_met_accts_ext table

48: Errcd := SQLCODE;
49: END get_amt_within_approval_limits;
50:
51:
52: -- Select amounts from jl_br_ar_rec_met_accts_ext table
53: PROCEDURE get_bank_account_amounts (rcpt_mthd IN NUMBER,
54: bnk_acct IN NUMBER,
55: perc_tol IN OUT NOCOPY NUMBER,
56: amt_tol IN OUT NOCOPY NUMBER,

Line 78: FROM jl_br_ar_rec_met_accts_ext

74: calculated_interest_rectrx_id
75: INTO perc_tol, amt_tol, writeoff_rectrx,
76: writeoff_ccid, rev_rectrx, rev_ccid,
77: calc_intr_ccid, calc_intr_rectx_id
78: FROM jl_br_ar_rec_met_accts_ext
79: WHERE receipt_method_id = rcpt_mthd
80: AND bank_acct_use_id = bnk_acct
81: AND rownum = row_number;
82: EXCEPTION

Line 277: FROM jl_br_ar_rec_met_accts_ext ext,

273: BEGIN
274: Errcd := 0;
275: SELECT COUNT (ext.receipt_method_id)
276: INTO total_rec
277: FROM jl_br_ar_rec_met_accts_ext ext,
278: ar_receipt_methods arm
279: WHERE arm.receipt_method_id = ext.receipt_method_id
280: AND arm.receipt_class_id = rcpt_class_id;
281: EXCEPTION