DBA Data[Home] [Help]

APPS.JAI_AP_MATCH_TAX_PKG dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 947: FROM ap_system_parameters_all

943: WHERE invoice_id = inv_id;
944:
945: CURSOR for_acct_id(orgn_id NUMBER) IS
946: SELECT accts_pay_code_combination_id
947: FROM ap_system_parameters_all
948: WHERE NVL(org_id, -1) = NVL(orgn_id, -1);--uncommented and modified by kunkumar for bug 5593895
949: --commented the above by Sanjikum For Bug#4474501, as this cursor is not being used anywhere
950:
951: CURSOR for_dist_insertion(cpn_invoice_id NUMBER, cpn_inv_line_num NUMBER,cpn_min_dist_line_num NUMBER) IS /* Picks up dtls from std apps inserted line */

Line 7341: FROM ap_system_parameters_all

7337: WHERE invoice_id = inv_id;
7338:
7339: /*CURSOR for_acct_id(orgn_id NUMBER) IS
7340: SELECT accts_pay_code_combination_id
7341: FROM ap_system_parameters_all
7342: WHERE NVL(org_id, 0) = NVL(orgn_id, 0);
7343: */
7344: --commented the above by Sanjikum For Bug#4474501, as this cursor is not being used anywhere
7345: