eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.GHR_EHRI_DYNRPT dependencies on GHR_NOA_FAMILIES

Line 483: FROM ghr_noa_families nfa

479: -- Bug#5168568 Removed Information type GHR_US_PAR_ETHNICITY_RACE
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)

Line 496: FROM ghr_noa_families nfa

492:
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)

Line 2643: from ghr_noa_families nof,

2639: Cursor c_noa_family(p_noa_id in number,
2640: p_effective_date in date)
2641: is
2642: Select fam.noa_family_code
2643: from ghr_noa_families nof,
2644: ghr_families fam
2645: where nof.nature_of_action_id = p_noa_id
2646: and fam.noa_family_code = nof.noa_family_code
2647: and nvl(fam.proc_method_flag,hr_api.g_varchar2) = 'Y'