DBA Data[Home] [Help]

APPS.JAI_AR_RCTLA_TRIGGER_PKG dependencies on JAI_CMN_FIN_YEARS

Line 1176: FROM JAI_CMN_FIN_YEARS A

1172: v_calc_tax_amount NUMBER;
1173:
1174: CURSOR fin_year_cur(p_org_id IN NUMBER) IS
1175: SELECT MAX(A.fin_year)
1176: FROM JAI_CMN_FIN_YEARS A
1177: WHERE organization_id = p_org_id AND fin_active_flag = 'Y';
1178:
1179: CURSOR rg_bal_cur(p_organization_id NUMBER, p_location_id NUMBER)IS
1180: SELECT NVL(rg23a_balance,0) rg23a_balance ,NVL(rg23c_balance,0) rg23c_balance,NVL(pla_balance,0) pla_balance