APPS.PER_PCL_BUS dependencies on PER_GRADE_SPINES_F

Line 1059: -- grade_spine_id should be refrenced from per_grade_spines_f.

1055: -- Desciption :
1056: --
1057: -- Validate that on insert and update grade_spine_id,parent_spine_id,step_id
1058: -- are not null WHEN category is pay scale.
1059: -- grade_spine_id should be refrenced from per_grade_spines_f.
1060: --
1061: --
1062: -- Pre-conditions :
1063: --

Line 1105: FROM per_grade_spines_f pgs

1101:
1102:
1103: CURSOR csr_chk_grd_fk_start IS
1104: SELECT 'Y'
1105: FROM per_grade_spines_f pgs
1106: WHERE pgs.grade_spine_id = p_grade_spine_id
1107: AND p_validation_start_date between pgs.effective_start_date and pgs.effective_end_date ;
1108:
1109:

Line 1112: FROM per_grade_spines_f pgs

1108:
1109:
1110: CURSOR csr_chk_grd_fk_end IS
1111: SELECT 'Y'
1112: FROM per_grade_spines_f pgs
1113: WHERE pgs.grade_spine_id = p_grade_spine_id
1114: AND p_validation_end_date between pgs.effective_start_date and pgs.effective_end_date ;
1115:
1116:

Line 1995: (p_base_table_name => 'per_grade_spines_f'

1991: );
1992: --
1993: If ((nvl(p_grade_spine_id, hr_api.g_number) <> hr_api.g_number) and
1994: NOT (dt_api.check_min_max_dates
1995: (p_base_table_name => 'per_grade_spines_f'
1996: ,p_base_key_column => 'GRADE_SPINE_ID'
1997: ,p_base_key_value => p_grade_spine_id
1998: ,p_from_date => p_validation_start_date
1999: ,p_to_date => p_validation_end_date))) Then