APPS.PQH_WDT_BUS dependencies on PQH_WORKSHEETS

Line 187: from pqh_worksheets a

183: l_dummy varchar2(1);
184: --
185: cursor c1 is
186: select null
187: from pqh_worksheets a
188: where a.worksheet_id = p_worksheet_id;
189: --
190: Begin
191: --

Line 203: -- check if worksheet_id value exists in pqh_worksheets table

199: and nvl(p_worksheet_id,hr_api.g_number)
200: <> nvl(pqh_wdt_shd.g_old_rec.worksheet_id,hr_api.g_number)
201: or not l_api_updating) then
202: --
203: -- check if worksheet_id value exists in pqh_worksheets table
204: --
205: open c1;
206: --
207: fetch c1 into l_dummy;

Line 212: -- raise error as FK does not relate to PK in pqh_worksheets

208: if c1%notfound then
209: --
210: close c1;
211: --
212: -- raise error as FK does not relate to PK in pqh_worksheets
213: -- table.
214: --
215: pqh_wdt_shd.constraint_error('PQH_WORKSHEET_DETAILS_FK7');
216: --

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 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: --