APPS.PER_PGS_BUS dependencies on PER_GRADES

Line 332: -- exists in per_grades table

328: -- ----------------------------------------------------------------------------
329: --
330: -- Description
331: -- This procedure is used to check that the grade_id is mandatory,
332: -- exists in per_grades table
333: -- and effective_date between date_from and date_to.
334: --
335: -- Pre Conditions
336: -- None.

Line 372: from per_grades pg

368: --
369:
370: cursor csr_valid_grade_id is
371: select null
372: from per_grades pg
373: where pg.grade_id = p_grade_id
374: and business_group_id = p_business_group_id
375: and p_effective_date between pg.date_from
376: and nvl(pg.date_to, hr_api.g_eot);

Line 410: -- Check that the grade_id should exist in per_grades and has the business group

406:
407: hr_utility.set_location(l_proc, 20);
408:
409: --
410: -- Check that the grade_id should exist in per_grades and has the business group
411: --
412: open csr_valid_grade_id;
413: fetch csr_valid_grade_id into l_exists;
414: if csr_valid_grade_id%notfound then