DBA Data[Home] [Help]

APPS.JAI_AP_MATCH_TAX_PKG dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 690: FROM ap_system_parameters_all

686: WHERE invoice_id = inv_id;
687:
688: CURSOR for_acct_id(orgn_id NUMBER) IS
689: SELECT accts_pay_code_combination_id
690: FROM ap_system_parameters_all
691: WHERE NVL(org_id, -1) = NVL(orgn_id, -1);--uncommented and modified by kunkumar for bug 5593895
692: --commented the above by Sanjikum For Bug#4474501, as this cursor is not being used anywhere
693:
694: 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 5791: FROM ap_system_parameters_all

5787: WHERE invoice_id = inv_id;
5788:
5789: /*CURSOR for_acct_id(orgn_id NUMBER) IS
5790: SELECT accts_pay_code_combination_id
5791: FROM ap_system_parameters_all
5792: WHERE NVL(org_id, 0) = NVL(orgn_id, 0);
5793: */
5794: --commented the above by Sanjikum For Bug#4474501, as this cursor is not being used anywhere
5795: