eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.JAI_GENERAL_PKG dependencies on JAI_CMN_RG_PLA_TRXS

Line 455: SELECT register_id FROM JAI_CMN_RG_PLA_TRXS

451: AND fin_year = cp_fin_year);
452:
453: -- PLA
454: CURSOR c_pla(cp_fin_year IN NUMBER) IS
455: SELECT register_id FROM JAI_CMN_RG_PLA_TRXS
456: WHERE organization_id = p_organization_id
457: AND location_id = p_location_id
458: AND fin_year = cp_fin_year
459: AND slno = (select max(slno) from JAI_CMN_RG_PLA_TRXS

Line 459: AND slno = (select max(slno) from JAI_CMN_RG_PLA_TRXS

455: SELECT register_id FROM JAI_CMN_RG_PLA_TRXS
456: WHERE organization_id = p_organization_id
457: AND location_id = p_location_id
458: AND fin_year = cp_fin_year
459: AND slno = (select max(slno) from JAI_CMN_RG_PLA_TRXS
460: WHERE organization_id = p_organization_id
461: AND location_id = p_location_id
462: AND fin_year = cp_fin_year);
463: