DBA Data[Home] [Help]

APPS.GHR_MASS_AWARDS_ELIG dependencies on GHR_HISTORY_FETCH

Line 891: ghr_history_fetch.fetch_positionei

887: l_cursor_pos_grp1_id := DBMS_SQL.OPEN_CURSOR;
888: DBMS_SQL.PARSE(l_cursor_pos_grp1_id,l_pos_grp1_select,DBMS_SQL.NATIVE);
889:
890: -- Get POS gRP1 from history
891: ghr_history_fetch.fetch_positionei
892: (p_position_id => l_pos_id,
893: p_information_type => 'GHR_US_POS_GRP1',
894: p_date_effective => l_effective_date,
895: p_pos_ei_data => l_pos_ei_data

Line 916: ghr_history_fetch.fetch_positionei

912: l_cursor_pos_grp2_id := DBMS_SQL.OPEN_CURSOR;
913: DBMS_SQL.PARSE(l_cursor_pos_grp2_id,l_pos_grp2_select,DBMS_SQL.NATIVE);
914:
915: -- Get POS gRP2 from history
916: ghr_history_fetch.fetch_positionei
917: (p_position_id => l_pos_id,
918: p_information_type => 'GHR_US_POS_GRP2',
919: p_date_effective => l_effective_date,
920: p_pos_ei_data => l_pos_ei_data

Line 940: ghr_history_fetch.fetch_positionei

936:
937: If l_pay_plan_exists or l_grade_exists then
938:
939: -- Get POSITION VALID GRADE from history
940: ghr_history_fetch.fetch_positionei
941: (p_position_id => l_pos_id,
942: p_information_type => 'GHR_US_POS_VALID_GRADE',
943: p_date_effective => l_effective_date,
944: p_pos_ei_data => l_pos_ei_data