APPS.JAI_AP_TOLERANCE_PKG dependencies on JAI_AP_TOL_SETUPS_ALL

Line 18: FROM JAI_AP_TOL_SETUPS_ALL

14: ) IS
15:
16: CURSOR set_up_values IS
17: SELECT *
18: FROM JAI_AP_TOL_SETUPS_ALL
19: where org_id = p_org_id;
20:
21: CURSOR check_entry(inv_id NUMBER, cp_vat_code ap_invoice_distributions_all.vat_code%type) IS
22: SELECT 1

Line 41: FROM JAI_AP_TOL_SETUPS_ALL;

37:
38: CURSOR least_values(h_amt NUMBER) IS
39: SELECT least(h_amt*NVL(tolerance_pos_percent,0)/100, NVL(tolerance_pos_amt,0)) max_val,
40: least(h_amt*NVL(tolerance_neg_percent,0)/100, NVL(tolerance_neg_amt,0)) min_val
41: FROM JAI_AP_TOL_SETUPS_ALL;
42:
43: CURSOR from_inv_dist(inv_id NUMBER,
44: cp_description ap_invoice_distributions_all.description%type,
45: cp_invoice_line_number ap_invoice_lines_all.line_number%TYPE,