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.HRI_OPL_BDGTS dependencies on PQH_BUDGET_VERSIONS

Line 400: pqh_budget_versions ver

396: ver.budget_version_id,
397: ver.date_from,
398: ver.date_to
399: FROM pqh_budgets bdgt,
400: pqh_budget_versions ver
401: WHERE bdgt.position_control_flag = 'Y'
402: AND bdgt.budgeted_entity_cd IN ('ORGANIZATION','POSITION')
403: AND bdgt.budget_id = ver.budget_id
404: AND (( bdgt.budget_start_date BETWEEN g_refresh_start_date AND g_refresh_end_date )

Line 407: FROM pqh_budget_versions pbv

403: AND bdgt.budget_id = ver.budget_id
404: AND (( bdgt.budget_start_date BETWEEN g_refresh_start_date AND g_refresh_end_date )
405: OR ( g_refresh_start_date BETWEEN bdgt.budget_start_date AND bdgt.budget_end_date ))
406: AND ver.budget_version_id = ( SELECT max(budget_version_id)
407: FROM pqh_budget_versions pbv
408: WHERE pbv.budget_id = bdgt.budget_id );
409: BEGIN
410: --
411: dbg('Inside process');