DBA Data[Home] [Help]

APPS.GHR_EHRI_DYNRPT dependencies on GHR_NOA_FAMILIES

Line 481: FROM ghr_noa_families nfa

477: -- Bug#5168568 Removed Information type GHR_US_PAR_ETHNICITY_RACE
478: -- Having this EIT in the list is skipping the printing of Military service, frozen service.
479: CURSOR c_rit IS
480: SELECT rit.information_type
481: FROM ghr_noa_families nfa
482: ,ghr_pa_request_info_types rit
483: WHERE rit.noa_family_code = nfa.noa_family_code
484: AND (nfa.nature_of_action_id = p_first_noa_id
485: OR nfa.nature_of_action_id = p_second_noa_id)

Line 494: FROM ghr_noa_families nfa

490:
491: CURSOR rpa_eit_ben
492: IS
493: SELECT rit.information_type
494: FROM ghr_noa_families nfa
495: ,ghr_pa_request_info_types rit
496: WHERE rit.noa_family_code = nfa.noa_family_code
497: AND (nfa.nature_of_action_id = p_first_noa_id
498: OR nfa.nature_of_action_id = p_second_noa_id)