APPS.PQH_WPR_BUS dependencies on PQH_WORKSHEET_DETAILS

Line 261: from pqh_worksheet_details a

257: l_dummy varchar2(1);
258: --
259: cursor c1 is
260: select null
261: from pqh_worksheet_details a
262: where a.worksheet_detail_id = p_worksheet_detail_id;
263: --
264: Begin
265: --

Line 277: -- check if worksheet_detail_id value exists in pqh_worksheet_details table

273: and nvl(p_worksheet_detail_id,hr_api.g_number)
274: <> nvl(pqh_wpr_shd.g_old_rec.worksheet_detail_id,hr_api.g_number)
275: or not l_api_updating) then
276: --
277: -- check if worksheet_detail_id value exists in pqh_worksheet_details table
278: --
279: open c1;
280: --
281: fetch c1 into l_dummy;

Line 286: -- raise error as FK does not relate to PK in pqh_worksheet_details

282: if c1%notfound then
283: --
284: close c1;
285: --
286: -- raise error as FK does not relate to PK in pqh_worksheet_details
287: -- table.
288: --
289: pqh_wpr_shd.constraint_error('PQH_WORKSHEET_PERIODS_FK1');
290: --

Line 707: From pqh_budgets bdt, pqh_worksheets wks , pqh_worksheet_details wdt

703: where a.time_period_id = p_end_time_period_id;
704: --
705: Cursor c3 is
706: Select bdt.BUDGET_START_DATE,bdt.BUDGET_END_DATE
707: From pqh_budgets bdt, pqh_worksheets wks , pqh_worksheet_details wdt
708: Where wdt.worksheet_detail_id = p_worksheet_detail_id
709: ANd wdt.worksheet_id = wks.worksheet_id
710: AND wks.budget_id = bdt.budget_id;
711: Begin