[Home] [Help]
1055: WHERE order_type_id = pr_new.batch_source_id AND order_flag= 'N'); /* Modified by Ramananda for removal of SQL LITERALs */
1056:
1057: CURSOR fin_year_cur(p_org_id IN NUMBER) IS
1058: SELECT MAX(A.fin_year)
1059: FROM JAI_CMN_FIN_YEARS A
1060: WHERE organization_id = p_org_id AND fin_active_flag = 'Y';
1061:
1062: CURSOR tax_amount_cur IS
1063: SELECT NVL(tax_amount,0) tax_amount