APPS.PER_SPS_BUS dependencies on PER_GRADE_SPINES_F

Line 254: -- in per_grade_spines_f to be refered by grade_spine_id to be passed as

250: --
251: -- Validates business_group_id in per_spinal_points talble should be
252: -- the same as business_group_id to be passed as a parameter and
253: -- parent_spine_id in per_spinal_points should be the same as parent_spine_id
254: -- in per_grade_spines_f to be refered by grade_spine_id to be passed as
255: -- a parameter.
256: --
257: -- Pre-conditions:
258: -- step_id must be valid.

Line 305: ,per_grade_spines_f pgs

301: --
302: cursor csr_valid_parent_spine is
303: select null
304: from per_spinal_points psp
305: ,per_grade_spines_f pgs
306: where psp.business_group_id = p_business_group_id
307: and psp.spinal_point_id = p_spinal_point_id
308: and pgs.grade_spine_id = p_grade_spine_id
309: and pgs.business_group_id = p_business_group_id

Line 357: -- parent_spine_id in per_grade_spines_f

353: hr_utility.set_location(l_proc, 30);
354:
355: --
356: -- check parent_spine_id in per_spinal_points is the same as
357: -- parent_spine_id in per_grade_spines_f
358: --
359: open csr_valid_parent_spine;
360: fetch csr_valid_parent_spine into l_exists;
361: if csr_valid_parent_spine%notfound then

Line 424: from per_grade_spines_f pgs

420: l_api_updating boolean;
421: --
422: cursor csr_valid_grade_spine is
423: select null
424: from per_grade_spines_f pgs
425: where pgs.business_group_id = p_business_group_id
426: and pgs.grade_spine_id = p_grade_spine_id
427: and p_effective_date between
428: pgs.effective_start_date and pgs.effective_end_date;

Line 744: select 'X' from per_grade_spines_f

740: is getting purged and the cursor checks wheather the current step
741: is used as a ceiling step in its life time . */
742:
743: cursor csr_ceiling_chk is
744: select 'X' from per_grade_spines_f
745: where ceiling_step_id=p_step_id
746: and grade_spine_id=l_grade_spine_id
747: and p_effective_date<>effective_start_date;
748: /* This cusor will be called when the grade step

Line 753: select 'X' from per_grade_spines_f

749: is getting end dated and checks wheather the current step is
750: used as a ceiling step in future . */
751:
752: cursor csr_ceiling_chk2 IS
753: select 'X' from per_grade_spines_f
754: where ceiling_step_id = p_step_id and
755: grade_spine_id=l_grade_spine_id and
756: p_effective_date <= effective_end_date;
757:

Line 1178: (p_base_table_name => 'per_grade_spines_f'

1174: );
1175: --
1176: If ((nvl(p_grade_spine_id, hr_api.g_number) <> hr_api.g_number) and
1177: NOT (dt_api.check_min_max_dates
1178: (p_base_table_name => 'per_grade_spines_f'
1179: ,p_base_key_column => 'GRADE_SPINE_ID'
1180: ,p_base_key_value => p_grade_spine_id
1181: ,p_from_date => p_validation_start_date
1182: ,p_to_date => p_validation_end_date))) Then