DBA Data[Home] [Help]

APPS.PQH_WKS_BUDGET dependencies on HR_POSITIONS_F

Line 1011: hr_positions_f

1007: start with organization_id_parent = p_start_organization_id
1008: and org_structure_version_id = p_org_hier_ver
1009: union
1010: select p_start_organization_id organization_id_child from dual )x,
1011: hr_positions_f
1012: where pqh_budget.already_budgeted_pos(position_id) = 'FALSE'
1013: and get_position_budget_flag(availability_status_id) = 'Y'
1014: and effective_start_date < l_budget_end_date
1015: and effective_end_date > l_budget_start_date