APPS.PQH_BUDGET dependencies on DUAL

Line 1930: select p_start_organization_id organization_id_child from dual )x

1926: where org_structure_version_id = p_org_hier_ver
1927: connect by prior organization_id_child = organization_id_parent and org_structure_version_id = p_org_hier_ver
1928: start with organization_id_parent = p_start_organization_id and org_structure_version_id = p_org_hier_ver
1929: union all
1930: select p_start_organization_id organization_id_child from dual )x
1931: , pqh_budget_details bud
1932: where bud.budget_version_id = p_budget_version_id
1933: and bud.organization_id = x.organization_id_child;
1934: cursor c3 is select position_id , grade_id, bud.organization_id organization_id, job_id,budget_detail_id,

Line 1954: select p_start_organization_id organization_id_child from dual )x

1950: where org_structure_version_id = p_org_hier_ver
1951: connect by prior organization_id_child = organization_id_parent and org_structure_version_id = p_org_hier_ver
1952: start with organization_id_parent = p_start_organization_id and org_structure_version_id = p_org_hier_ver
1953: union all
1954: select p_start_organization_id organization_id_child from dual )x
1955: , pqh_budget_details
1956: where pqh_budget.already_budgeted_org(organization_id) = 'FALSE'
1957: and budget_version_id = p_budget_version_id
1958: and organization_id = x.organization_id_child;

Line 2595: select p_start_organization_id organization_id_child from dual;

2591: and org_structure_version_id = p_org_hier_ver
2592: start with organization_id_parent = p_start_organization_id
2593: and org_structure_version_id = p_org_hier_ver
2594: union all
2595: select p_start_organization_id organization_id_child from dual;
2596: cursor csr_pos(p_organization_id number) is
2597: select position_id,job_id,organization_id,availability_status_id
2598: from hr_positions
2599: where effective_start_date < l_budget_end_date

Line 2695: select p_start_organization_id organization_id_child from dual )x,

2691: where org_structure_version_id = p_org_hier_ver
2692: connect by prior organization_id_child = organization_id_parent and org_structure_version_id = p_org_hier_ver
2693: start with organization_id_parent = p_start_organization_id and org_structure_version_id = p_org_hier_ver
2694: union all
2695: select p_start_organization_id organization_id_child from dual )x,
2696: hr_organization_units
2697: where pqh_budget.already_budgeted_org(organization_id) = 'FALSE'
2698: and date_from < l_budget_end_date
2699: and (date_to > l_budget_start_date or date_to is null)

Line 4727: select p_start_organization_id organization_id_child from dual )x

4723: where org_structure_version_id = p_org_hier_ver
4724: connect by prior organization_id_child = organization_id_parent and org_structure_version_id = p_org_hier_ver
4725: start with organization_id_parent = p_start_organization_id and org_structure_version_id = p_org_hier_ver
4726: union all
4727: select p_start_organization_id organization_id_child from dual )x
4728: , pqh_budget_details bud
4729: where pqh_budget.already_budgeted_pos(bud.position_id) = 'FALSE'
4730: and bud.budget_version_id = p_budget_version_id
4731: and bud.organization_id = x.organization_id_child;

Line 4744: select p_start_organization_id organization_id_child from dual )x

4740: where org_structure_version_id = p_org_hier_ver
4741: connect by prior organization_id_child = organization_id_parent and org_structure_version_id = p_org_hier_ver
4742: start with organization_id_parent = p_start_organization_id and org_structure_version_id = p_org_hier_ver
4743: union all
4744: select p_start_organization_id organization_id_child from dual )x
4745: , pqh_budget_details
4746: where pqh_budget.already_budgeted_org(organization_id) = 'FALSE'
4747: and budget_version_id = p_budget_version_id
4748: and organization_id = x.organization_id_child;