APPS.GHR_MASS_AWARDS_PKG dependencies on GHR_PA_REQUEST_SHADOW

Line 425: FROM ghr_pa_request_shadow

421: SELECT
422: award_amount,
423: award_uom,
424: award_percentage
425: FROM ghr_pa_request_shadow
426: WHERE pa_request_id = p_pa_request_id;
427:
428: CURSOR cur_award_ei_shadow IS
429: SELECT rei_information3 award_agency,

Line 678: delete from ghr_pa_request_shadow

674: where pa_request_id = l_pa_request_id;
675:
676: -- Delete the shadow information
677: hr_utility.set_location( l_proc,20);
678: delete from ghr_pa_request_shadow
679: where pa_request_id = l_pa_request_id;
680:
681: -- Delete the database extra information for the given person_id
682: hr_utility.set_location( l_proc,25);

Line 2979: insert into ghr_pa_request_shadow(

2975: End set_ei;
2976:
2977: Procedure create_shadow_row ( p_rpa_data in ghr_pa_requests%rowtype) is
2978: Begin
2979: insert into ghr_pa_request_shadow(
2980: pa_request_id
2981: ,academic_discipline
2982: ,annuitant_indicator
2983: ,appropriation_code1

Line 3088: update ghr_pa_request_shadow

3084:
3085: Procedure update_shadow_row ( p_rpa_data in ghr_pa_requests%rowtype,
3086: p_result out nocopy Boolean ) is
3087: Begin
3088: update ghr_pa_request_shadow
3089: set
3090: academic_discipline = p_rpa_data.academic_discipline
3091: ,annuitant_indicator = p_rpa_data.annuitant_indicator
3092: ,appropriation_code1 = p_rpa_data.appropriation_code1