APPS.PQH_WDT_BUS dependencies on PQH_BUDGETS

Line 260: l_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%type;

256: --
257: l_proc varchar2(72) := g_package||'chk_grade_id';
258: l_api_updating boolean;
259: l_dummy varchar2(1);
260: l_budgeted_entity_cd pqh_budgets.budgeted_entity_cd%type;
261: --
262: --
263: cursor c1 is
264: select null

Line 270: From pqh_budgets bdt,pqh_worksheets wks

266: where a.grade_id = p_grade_id;
267: --
268: Cursor c2 is
269: select budgeted_entity_cd
270: From pqh_budgets bdt,pqh_worksheets wks
271: Where wks.worksheet_id = p_worksheet_id
272: ANd bdt.budget_id = wks.budget_id;
273: --
274: Begin

Line 600: l_org_structure_version_id pqh_budgets.org_structure_version_id%type;

596: l_proc varchar2(72) := g_package||'chk_organization_id';
597: l_api_updating boolean;
598: l_dummy varchar2(1);
599: --
600: l_org_structure_version_id pqh_budgets.org_structure_version_id%type;
601: l_start_organization_id pqh_budgets.start_organization_id%type;
602: --
603: cursor c1 is
604: select null

Line 601: l_start_organization_id pqh_budgets.start_organization_id%type;

597: l_api_updating boolean;
598: l_dummy varchar2(1);
599: --
600: l_org_structure_version_id pqh_budgets.org_structure_version_id%type;
601: l_start_organization_id pqh_budgets.start_organization_id%type;
602: --
603: cursor c1 is
604: select null
605: from hr_all_organization_units a

Line 610: From pqh_worksheets wfs , pqh_budgets bdt

606: where a.organization_id = p_organization_id;
607: --
608: Cursor c2 is
609: Select start_organization_id,org_structure_version_id
610: From pqh_worksheets wfs , pqh_budgets bdt
611: Where wfs.worksheet_id = p_worksheet_id
612: AND wfs.budget_id = bdt.budget_id;
613: --
614: --