APPS.PQH_WKS_BUDGET dependencies on PQH_WORKSHEET_ORGANIZATIONS_V

Line 1003: from ( select organization_id_child from pqh_worksheet_organizations_v

999: and pqh_budget.already_budgeted_pos(position_id) = 'FALSE'
1000: and get_position_budget_flag(pos.availability_status_id) = 'Y';
1001: cursor c2 is select distinct --Added Distinct to eliminate duplicates from the cursor to fix the bug#10284825.
1002: position_id,job_id,organization_id
1003: from ( select organization_id_child from pqh_worksheet_organizations_v
1004: where org_structure_version_id = p_org_hier_ver
1005: connect by prior organization_id_child = organization_id_parent
1006: and org_structure_version_id = p_org_hier_ver
1007: start with organization_id_parent = p_start_organization_id

Line 1115: from pqh_worksheet_organizations_v w

1111: HR_SECURITY.SHOW_RECORD('HR_ALL_ORGANIZATION_UNITS', ORGANIZATION_ID))='TRUE'
1112: --and decode(hr_general.get_xbg_profile,'Y', business_group_id , hr_general.get_business_group_id) = business_group_id
1113: and pqh_budget.already_budgeted_org(organization_id) = 'FALSE';
1114: cursor c2 is select w.organization_id_child organization_id
1115: from pqh_worksheet_organizations_v w
1116: where org_structure_version_id = p_org_hier_ver
1117: and pqh_budget.already_budgeted_org(w.organization_id_child) = 'FALSE'
1118: and exists
1119: (select null