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.PQH_WKS_BUDGET dependencies on HR_POSITIONS

Line 989: from hr_positions pos,hr_organization_units org

985: from pqh_budgets bgt, pqh_budget_versions bgv
986: where bgv.budget_id = bgt.budget_id
987: and bgv.budget_version_id = p_budget_version_id;
988: cursor c1 is select position_id,job_id,pos.organization_id organization_id
989: from hr_positions pos,hr_organization_units org
990: where org.business_group_id = p_business_group_id
991: and pos.business_group_id = p_business_group_id
992: and pos.organization_id = org.organization_id
993: and pos.effective_start_date < l_budget_end_date

Line 1006: hr_positions_f

1002: start with organization_id_parent = p_start_organization_id
1003: and org_structure_version_id = p_org_hier_ver
1004: union
1005: select p_start_organization_id organization_id_child from dual )x,
1006: hr_positions_f
1007: where pqh_budget.already_budgeted_pos(position_id) = 'FALSE'
1008: and get_position_budget_flag(availability_status_id) = 'Y'
1009: and effective_start_date < l_budget_end_date
1010: and effective_end_date > l_budget_start_date