APPS.PQH_WKS_BUDGET dependencies on PQH_WORKSHEET_ORGANIZATIONS_V

Line 998: from ( select organization_id_child from pqh_worksheet_organizations_v

994: and pos.effective_end_date > l_budget_start_date
995: and pqh_budget.already_budgeted_pos(position_id) = 'FALSE'
996: and get_position_budget_flag(pos.availability_status_id) = 'Y';
997: cursor c2 is select position_id,job_id,organization_id
998: from ( select organization_id_child from pqh_worksheet_organizations_v
999: where org_structure_version_id = p_org_hier_ver
1000: connect by prior organization_id_child = organization_id_parent
1001: and org_structure_version_id = p_org_hier_ver
1002: start with organization_id_parent = p_start_organization_id

Line 1110: from pqh_worksheet_organizations_v w

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