APPS.JL_ZZ_AP_MONOTRIB_AWT_PKG dependencies on JL_AR_AP_MTBT_THRESHOLDS

Line 88: FROM jl_ar_ap_mtbt_thresholds

84: BEGIN
85:
86:
87: SELECT nvl(threshold_amt,0) INTO p_goods_supp_thld
88: FROM jl_ar_ap_mtbt_thresholds
89: WHERE contributor_type = 'GOODS'
90: AND p_report_date BETWEEN start_date AND nvl(end_date,add_months(sysdate,12*50));
91:
92: EXCEPTION

Line 100: FROM JL_AR_AP_MTBT_THRESHOLDS

96:
97: BEGIN
98:
99: SELECT nvl(threshold_amt,0) INTO p_service_supp_thld
100: FROM JL_AR_AP_MTBT_THRESHOLDS
101: WHERE contributor_type = 'SERVICES'
102: AND p_report_date BETWEEN start_date AND nvl(end_date,add_months(sysdate,12*50));
103:
104: EXCEPTION