DBA Data[Home] [Help]

APPS.PQH_WKS_BUDGET dependencies on DUAL

Line 1005: select p_start_organization_id organization_id_child from dual )x,

1001: and org_structure_version_id = p_org_hier_ver
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