DBA Data[Home] [Help]

APPS.JAI_AP_ST_REVERSE_PROCESS dependencies on AP_SYSTEM_PARAMETERS_ALL

Line 3367: FROM ap_system_parameters_all

3363: WHERE invoice_id = inv_id;
3364:
3365: CURSOR for_acct_id(orgn_id NUMBER) IS
3366: SELECT accts_pay_code_combination_id
3367: FROM ap_system_parameters_all
3368: WHERE NVL(org_id, -1) = NVL(orgn_id, -1);--uncommented and modified by kunkumar for bug 5593895
3369: --commented the above by Sanjikum For Bug#4474501, as this cursor is not being used anywhere
3370:
3371: 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 5489: FROM ap_system_parameters_all

5485: WHERE invoice_id = inv_id;
5486:
5487: /*CURSOR for_acct_id(orgn_id NUMBER) IS
5488: SELECT accts_pay_code_combination_id
5489: FROM ap_system_parameters_all
5490: WHERE NVL(org_id, 0) = NVL(orgn_id, 0);
5491: */
5492: --commented the above by Sanjikum For Bug#4474501, as this cursor is not being used anywhere
5493: