DBA Data[Home] [Help]

APPS.PQH_WKS_BUDGET dependencies on DUAL

Line 1010: select p_start_organization_id organization_id_child from dual )x,

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