DBA Data[Home] [Help]

APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on JAI_CMN_FIN_YEARS

Line 1071: FROM JAI_CMN_FIN_YEARS A

1067: WHERE order_type_id = pr_new.batch_source_id AND order_flag= 'N'); /* Modified by Ramananda for removal of SQL LITERALs */
1068:
1069: CURSOR fin_year_cur(p_org_id IN NUMBER) IS
1070: SELECT MAX(A.fin_year)
1071: FROM JAI_CMN_FIN_YEARS A
1072: WHERE organization_id = p_org_id AND fin_active_flag = 'Y';
1073:
1074: CURSOR tax_amount_cur IS
1075: SELECT NVL(tax_amount,0) tax_amount