APPS.GHR_REI_BUS dependencies on GHR_PA_REQUEST_INFO_TYPES

Line 197: l_active_inactive_flag GHR_PA_REQUEST_INFO_TYPES.ACTIVE_INACTIVE_FLAG%TYPE;

193: --
194: -- {End Of Comments}
195: -- ----------------------------------------------------------------------------
196: l_proc varchar2(72) := g_package||'chk_pa_request_info_type';
197: l_active_inactive_flag GHR_PA_REQUEST_INFO_TYPES.ACTIVE_INACTIVE_FLAG%TYPE;
198: l_inactive_type exception;
199: --
200: CURSOR c_info_type IS
201: SELECT rit.multiple_occurrences_flag

Line 203: FROM ghr_pa_request_info_types rit

199: --
200: CURSOR c_info_type IS
201: SELECT rit.multiple_occurrences_flag
202: ,rit.active_inactive_flag
203: FROM ghr_pa_request_info_types rit
204: WHERE rit.information_type = p_information_type
205: ;
206: --
207: Begin

Line 676: l_multiple_occurrences_flag ghr_pa_request_info_types.multiple_occurrences_flag%type;

672: -- ----------------------------------------------------------------------------
673: Procedure insert_validate(p_rec in ghr_rei_shd.g_rec_type) is
674: --
675: l_proc varchar2(72) := g_package||'insert_validate';
676: l_multiple_occurrences_flag ghr_pa_request_info_types.multiple_occurrences_flag%type;
677: --
678: l_person_id per_people_f.person_id%type;
679: l_position_id per_positions.position_id%type;
680: l_bus_group_id per_people_f.business_group_id%type;