DBA Data[Home] [Help]

APPS.JAI_AR_IMPORT_SYNC_PKG dependencies on JAI_CMN_FIN_YEARS

Line 677: FROM JAI_CMN_FIN_YEARS A

673: WHERE order_type_id = pr_new.batch_source_id AND order_flag= 'N');
674:
675: CURSOR fin_year_cur(p_org_id IN NUMBER) IS
676: SELECT MAX(A.fin_year)
677: FROM JAI_CMN_FIN_YEARS A
678: WHERE organization_id = p_org_id AND fin_active_flag = 'Y';
679:
680: CURSOR tax_amount_cur IS
681: SELECT NVL(tax_amount,0) tax_amount