APPS.PER_GRS_BUS dependencies on FND_ID_FLEX_STRUCTURES

Line 162: -- FND_ID_FLEX_STRUCTURES table.

158: --
159: -- Validates that ID_FLEX_NUM is not null.
160: --
161: -- Validates that values enterd for this column exist in the
162: -- FND_ID_FLEX_STRUCTURES table.
163: --
164: -- Pre-conditions:
165: --
166: -- In Arguments :

Line 184: (p_id_flex_num in fnd_id_flex_structures.id_flex_num%TYPE

180: -- {End of Comments}
181: --
182: -- -----------------------------------------------------------------------
183: Procedure chk_id_flex_num
184: (p_id_flex_num in fnd_id_flex_structures.id_flex_num%TYPE
185: ) is
186: --
187: l_proc varchar2(72) := g_package||'chk_id_flex_num';
188: l_exists varchar2(2);

Line 194: from fnd_id_flex_structures fnd

190: -- Cursor to check that ID_FLEX_NUM exists
191: --
192: cursor csr_valid_id_flex_num is
193: select '1'
194: from fnd_id_flex_structures fnd
195: where fnd.id_flex_num = p_id_flex_num;
196: --
197: begin
198: hr_utility.set_location('Entering:'||l_proc,5);