APPS.GHR_PA_REQUESTS_PKG2 dependencies on PER_POSITION_EXTRA_INFO

Line 407: ,per_position_extra_info poi

403: CURSOR cur_pp IS
404: SELECT gdf.segment1 pay_plan
405: FROM per_grade_definitions gdf
406: ,per_grades grd
407: ,per_position_extra_info poi
408: WHERE poi.position_id = p_position_id
409: AND poi.information_type = 'GHR_US_POS_VALID_GRADE'
410: AND grd.grade_id = poi.poei_information3
411: AND grd.grade_definition_id = gdf.grade_definition_id;

Line 428: ,per_position_extra_info poi

424: CURSOR cur_pp IS
425: SELECT gdf.segment2 grade_or_level
426: FROM per_grade_definitions gdf
427: ,per_grades grd
428: ,per_position_extra_info poi
429: WHERE poi.position_id = p_position_id
430: AND poi.information_type = 'GHR_US_POS_VALID_GRADE'
431: AND grd.grade_id = poi.poei_information3
432: AND grd.grade_definition_id = gdf.grade_definition_id;

Line 465: l_expire_date PER_POSITION_EXTRA_INFO.POEI_INFORMATION3%type;

461: ,p_date in date)
462: RETURN BOOLEAN IS
463: --
464: l_chk_position_obligated boolean :=false;
465: l_expire_date PER_POSITION_EXTRA_INFO.POEI_INFORMATION3%type;
466: l_obligate_type PER_POSITION_EXTRA_INFO.POEI_INFORMATION4%type;
467: l_pos_ei_data PER_POSITION_EXTRA_INFO%ROWTYPE;
468:
469: BEGIN

Line 466: l_obligate_type PER_POSITION_EXTRA_INFO.POEI_INFORMATION4%type;

462: RETURN BOOLEAN IS
463: --
464: l_chk_position_obligated boolean :=false;
465: l_expire_date PER_POSITION_EXTRA_INFO.POEI_INFORMATION3%type;
466: l_obligate_type PER_POSITION_EXTRA_INFO.POEI_INFORMATION4%type;
467: l_pos_ei_data PER_POSITION_EXTRA_INFO%ROWTYPE;
468:
469: BEGIN
470:

Line 467: l_pos_ei_data PER_POSITION_EXTRA_INFO%ROWTYPE;

463: --
464: l_chk_position_obligated boolean :=false;
465: l_expire_date PER_POSITION_EXTRA_INFO.POEI_INFORMATION3%type;
466: l_obligate_type PER_POSITION_EXTRA_INFO.POEI_INFORMATION4%type;
467: l_pos_ei_data PER_POSITION_EXTRA_INFO%ROWTYPE;
468:
469: BEGIN
470:
471: ghr_history_fetch.fetch_positionei (p_position_id => p_position_id