APPS.PER_PCL_BUS dependencies on PER_SPINAL_POINT_STEPS_F

Line 1735: -- Validate that step_id is refrenced from per_spinal_point_steps_f.

1731: -- ---------------------------------------------------------------------------
1732: --
1733: -- Desciption :
1734: --
1735: -- Validate that step_id is refrenced from per_spinal_point_steps_f.
1736: --
1737: -- Pre-conditions :
1738: --
1739: --

Line 1781: FROM per_spinal_point_steps_f pspf

1777: AND pce.CAGR_ENTITLEMENT_ID = p_CAGR_ENTITLEMENT_ID;
1778:
1779: CURSOR csr_chk_step_fk_start IS
1780: SELECT 'Y'
1781: FROM per_spinal_point_steps_f pspf
1782: WHERE pspf.step_id = p_step_id
1783: AND p_validation_start_date
1784: BETWEEN pspf.effective_start_date AND pspf.effective_end_date ;
1785: --

Line 1788: FROM per_spinal_point_steps_f pspf

1784: BETWEEN pspf.effective_start_date AND pspf.effective_end_date ;
1785: --
1786: CURSOR csr_chk_step_fk_end IS
1787: SELECT 'Y'
1788: FROM per_spinal_point_steps_f pspf
1789: WHERE pspf.step_id = p_step_id
1790: AND p_validation_end_date
1791: BETWEEN pspf.effective_start_date AND pspf.effective_end_date ;
1792: --

Line 2005: (p_base_table_name => 'per_spinal_point_steps_f'

2001: raise l_integrity_error;
2002: End If;
2003: If ((nvl(p_step_id, hr_api.g_number) <> hr_api.g_number) and
2004: NOT (dt_api.check_min_max_dates
2005: (p_base_table_name => 'per_spinal_point_steps_f'
2006: ,p_base_key_column => 'STEP_ID'
2007: ,p_base_key_value => p_step_id
2008: ,p_from_date => p_validation_start_date
2009: ,p_to_date => p_validation_end_date))) Then

Line 2015: (p_base_table_name => 'per_spinal_point_steps_f'

2011: raise l_integrity_error;
2012: End If;
2013: If ((nvl(p_from_step_id, hr_api.g_number) <> hr_api.g_number) and
2014: NOT (dt_api.check_min_max_dates
2015: (p_base_table_name => 'per_spinal_point_steps_f'
2016: ,p_base_key_column => 'STEP_ID'
2017: ,p_base_key_value => p_from_step_id
2018: ,p_from_date => p_validation_start_date
2019: ,p_to_date => p_validation_end_date))) Then

Line 2025: (p_base_table_name => 'per_spinal_point_steps_f'

2021: raise l_integrity_error;
2022: End If;
2023: If ((nvl(p_to_step_id, hr_api.g_number) <> hr_api.g_number) and
2024: NOT (dt_api.check_min_max_dates
2025: (p_base_table_name => 'per_spinal_point_steps_f'
2026: ,p_base_key_column => 'STEP_ID'
2027: ,p_base_key_value => p_to_step_id
2028: ,p_from_date => p_validation_start_date
2029: ,p_to_date => p_validation_end_date))) Then