APPS.BEN_GRR_BUS dependencies on PER_GRADES

Line 86: -- PER_GRADES table.

82: --
83: -- Description
84: -- This procedure is used to check that the foreign key for the table
85: -- is created properly. a corresponding record should exist in the
86: -- PER_GRADES table.
87: --
88: -- Pre Conditions
89: -- None.
90: --

Line 92: -- grade_id FK of pointing to PER_GRADES tables.

88: -- Pre Conditions
89: -- None.
90: --
91: -- In Parameters
92: -- grade_id FK of pointing to PER_GRADES tables.
93: -- business_group_id or record being inserted or updated
94: -- effective_date Effective Date of session
95: --
96: -- Post Success

Line 112: from per_grades

108: --
109: l_proc varchar2(72) := g_package||'chk_grade_id';
110: l_dummy varchar2(1);
111: cursor c1 is select null
112: from per_grades
113: where grade_id = p_grade_id
114: and p_effective_date between nvl(date_from, p_effective_date)
115: and nvl(date_to, p_effective_date)
116: and business_group_id = p_business_group_id;