DBA Data[Home] [Help]

APPS.GHR_EHRI_DYNRPT dependencies on GHR_PA_REQUEST_INFO_TYPES

Line 482: ,ghr_pa_request_info_types rit

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)
486: AND rit.information_type IN ('GHR_US_PAR_AWARDS_BONUS' ,'GHR_US_PAR_APPT_INFO'

Line 495: ,ghr_pa_request_info_types rit

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)
499: AND rit.information_type IN ('GHR_US_PAR_BENEFIT_INFO' ,'GHR_US_PAR_RETIRMENT_SYS_INFO');