DBA Data[Home] [Help]

APPS.GHR_CPDF_DYNRPT dependencies on GHR_PA_REQUEST_INFO_TYPES

Line 410: ,ghr_pa_request_info_types rit

406: -- Having this EIT in the list is skipping the printing of Military service, frozen service.
407: CURSOR c_rit IS
408: SELECT rit.information_type
409: FROM ghr_noa_families nfa
410: ,ghr_pa_request_info_types rit
411: WHERE rit.noa_family_code = nfa.noa_family_code
412: AND (nfa.nature_of_action_id = p_first_noa_id
413: OR nfa.nature_of_action_id = p_second_noa_id)
414: AND rit.information_type IN ('GHR_US_PAR_AWARDS_BONUS' ,'GHR_US_PAR_APPT_INFO'