1198: -- ---------------------------------------------------------------------------
1199: --
1200: -- Desciption :
1201: --
1202: -- Validate parent_spine_id is refrenced from per_parent_spines_f.
1203: --
1204: --
1205: -- Pre-conditions :
1206: --
1239:
1240: --
1241: CURSOR csr_chk_parent_spine_fk IS
1242: SELECT 'Y'
1243: FROM per_parent_spines pps
1244: WHERE pps.parent_spine_id = p_parent_spine_id;
1245: --
1246: l_proc VARCHAR2(72) := g_package || 'chk_parent_spine_id';
1247: l_dummy VARCHAR2(1);