DBA Data[Home] [Help]

APPS.JAI_AR_RCTA_TRIGGER_PKG dependencies on JAI_CMN_FIN_YEARS

Line 1059: FROM JAI_CMN_FIN_YEARS A

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