DBA Data[Home] [Help]

APPS.GHR_EHRI_DYNRPT dependencies on GHR_PA_REQUEST_INFO_TYPES

Line 484: ,ghr_pa_request_info_types rit

480: -- Having this EIT in the list is skipping the printing of Military service, frozen service.
481: CURSOR c_rit IS
482: SELECT rit.information_type
483: FROM ghr_noa_families nfa
484: ,ghr_pa_request_info_types rit
485: WHERE rit.noa_family_code = nfa.noa_family_code
486: AND (nfa.nature_of_action_id = p_first_noa_id
487: OR nfa.nature_of_action_id = p_second_noa_id)
488: AND rit.information_type IN ('GHR_US_PAR_AWARDS_BONUS' ,'GHR_US_PAR_APPT_INFO'

Line 497: ,ghr_pa_request_info_types rit

493: CURSOR rpa_eit_ben
494: IS
495: SELECT rit.information_type
496: FROM ghr_noa_families nfa
497: ,ghr_pa_request_info_types rit
498: WHERE rit.noa_family_code = nfa.noa_family_code
499: AND (nfa.nature_of_action_id = p_first_noa_id
500: OR nfa.nature_of_action_id = p_second_noa_id)
501: AND rit.information_type IN ('GHR_US_PAR_BENEFIT_INFO' ,'GHR_US_PAR_RETIRMENT_SYS_INFO');