DBA Data[Home] [Help]

APPS.GHR_MASS_SEL_NOA dependencies on GHR_PA_REQUEST_EXTRA_INFO_S

Line 524: VALUES (ghr_pa_request_extra_info_s.nextval

520: INTO ghr_pa_request_ei_shadow (pa_request_extra_info_id
521: , pa_request_id
522: , information_type
523: , rei_information3)
524: VALUES (ghr_pa_request_extra_info_s.nextval
525: , p_pa_request_id
526: , l_information_type
527: , l_employment_type);
528: ELSIF p_noa_action IN ('280', '292') THEN

Line 534: VALUES (ghr_pa_request_extra_info_s.nextval

530: INTO ghr_pa_request_ei_shadow (pa_request_extra_info_id
531: , pa_request_id
532: , information_type
533: , rei_information8)
534: VALUES (ghr_pa_request_extra_info_s.nextval
535: , p_pa_request_id
536: , l_information_type
537: , l_employment_type);
538: ELSIF p_noa_action IN ('800') AND l_target_agency_code_subelmt IS NOT NULL THEN

Line 546: VALUES (ghr_pa_request_extra_info_s.nextval

542: , information_type
543: , rei_information3
544: , rei_information4
545: , rei_information5)
546: VALUES (ghr_pa_request_extra_info_s.nextval
547: , p_pa_request_id
548: , l_information_type
549: , l_eit_poi
550: ,l_pos_agency_code