DBA Data[Home] [Help]

APPS.PQH_BUDGET dependencies on PER_ORG_STRUCTURE_ELEMENTS

Line 1534: from per_org_structure_elements

1530: select organization_id
1531: from hr_positions
1532: where position_id = p_position_id;
1533: cursor c2 is select organization_id_child
1534: from per_org_structure_elements
1535: where org_structure_version_id = p_org_str_id
1536: connect by prior organization_id_child = organization_id_parent
1537: and org_structure_version_id = p_org_str_id
1538: start with organization_id_parent = p_delegate_org_id

Line 2770: from per_org_structure_elements hier, hr_organization_units org

2766: from pqh_budgets bgt, pqh_worksheets wks
2767: where wks.budget_id = bgt.budget_id
2768: and wks.worksheet_id = p_worksheet_id;
2769: cursor c1 is select hier.organization_id_child
2770: from per_org_structure_elements hier, hr_organization_units org
2771: where hier.org_structure_version_id = p_org_hier_ver
2772: and org.date_from < l_budget_end_date
2773: and (org.date_to > l_budget_start_date or org.date_to is null)
2774: and org.organization_id = hier.organization_id_child