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 2996: insert into ghr_pa_request_shadow(

2992: End set_ei;
2993:
2994: Procedure create_shadow_row ( p_rpa_data in ghr_pa_requests%rowtype) is
2995: Begin
2996: insert into ghr_pa_request_shadow(
2997: pa_request_id
2998: ,academic_discipline
2999: ,annuitant_indicator
3000: ,appropriation_code1

Line 3105: update ghr_pa_request_shadow

3101:
3102: Procedure update_shadow_row ( p_rpa_data in ghr_pa_requests%rowtype,
3103: p_result out nocopy Boolean ) is
3104: Begin
3105: update ghr_pa_request_shadow
3106: set
3107: academic_discipline = p_rpa_data.academic_discipline
3108: ,annuitant_indicator = p_rpa_data.annuitant_indicator
3109: ,appropriation_code1 = p_rpa_data.appropriation_code1