DBA Data[Home] [Help]

APPS.GHR_CPDF_DYNRPT dependencies on GHR_NOA_FAMILIES

Line 408: FROM ghr_noa_families nfa

404: -- Bug#5168568 Removed Information type GHR_US_PAR_ETHNICITY_RACE
405: -- Having this EIT in the list is skipping the printing of Military service, frozen service.
406: CURSOR c_rit IS
407: SELECT rit.information_type
408: FROM ghr_noa_families nfa
409: ,ghr_pa_request_info_types rit
410: WHERE rit.noa_family_code = nfa.noa_family_code
411: AND (nfa.nature_of_action_id = p_first_noa_id
412: OR nfa.nature_of_action_id = p_second_noa_id)