DBA Data[Home] [Help]

APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_CMN_FIN_YEARS

Line 1247: FROM JAI_CMN_FIN_YEARS A

1243: v_calc_tax_amount NUMBER;
1244:
1245: CURSOR fin_year_cur(p_org_id IN NUMBER) IS
1246: SELECT MAX(A.fin_year)
1247: FROM JAI_CMN_FIN_YEARS A
1248: WHERE organization_id = p_org_id AND fin_active_flag = 'Y';
1249:
1250: CURSOR rg_bal_cur(p_organization_id NUMBER, p_location_id NUMBER)IS
1251: SELECT NVL(rg23a_balance,0) rg23a_balance ,NVL(rg23c_balance,0) rg23c_balance,NVL(pla_balance,0) pla_balance