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_US_NFC_EXTRACTS dependencies on GHR_ADDRESSES_H_V

Line 122: FROM ghr_addresses_h_v gph

118: --Cursor to get address only when the rpa is appointment
119: CURSOR csr_per_add_apt (c_person_id in number
120: ,c_ext_end_date in date) is
121: SELECT gph.*
122: FROM ghr_addresses_h_v gph
123: WHERE gph.person_id = c_person_id
124: AND (gph.primary_flag='Y' OR gph.address_type = 'M') -- Bug 5037078
125: AND gph.business_group_id = g_business_group_id
126: AND gph.effective_date <= c_ext_end_date

Line 136: FROM ghr_addresses_h_v gph

132: CURSOR csr_per_add(c_person_id in number
133: ,c_ext_start_date in date
134: ,c_ext_end_date in date) is
135: SELECT gph.*
136: FROM ghr_addresses_h_v gph
137: WHERE gph.person_id = c_person_id
138: AND (gph.primary_flag='Y' OR gph.address_type = 'M') -- Bug 5037078
139: AND gph.business_group_id = g_business_group_id
140: AND(TRUNC(gph.effective_date) between c_ext_start_date

Line 375: FROM ghr_addresses_h_v gph

371: CURSOR c_get_pr_add (cp_person_id NUMBER
372: ,cp_ext_end_date Date)
373: IS
374: SELECT gph.*
375: FROM ghr_addresses_h_v gph
376: WHERE gph.person_id = cp_person_id
377: AND gph.primary_flag='Y'
378: AND gph.business_group_id = g_business_group_id
379: AND gph.effective_date <= cp_ext_end_date

Line 386: FROM ghr_addresses_h_v gph

382: CURSOR c_get_m_add (cp_person_id NUMBER
383: ,cp_ext_end_date Date)
384: IS
385: SELECT gph.*
386: FROM ghr_addresses_h_v gph
387: WHERE gph.person_id = cp_person_id
388: AND gph.address_type='M'
389: AND gph.business_group_id = g_business_group_id
390: AND gph.effective_date <= cp_ext_end_date

Line 607: FROM ghr_addresses_h_v gph

603: CURSOR c_get_pr_add (cp_person_id NUMBER
604: ,cp_ext_end_date Date)
605: IS
606: SELECT gph.*
607: FROM ghr_addresses_h_v gph
608: WHERE gph.person_id = cp_person_id
609: AND gph.primary_flag='Y'
610: AND gph.business_group_id = g_business_group_id
611: AND gph.effective_date <= cp_ext_end_date

Line 618: FROM ghr_addresses_h_v gph

614: CURSOR c_get_m_add (cp_person_id NUMBER
615: ,cp_ext_end_date Date)
616: IS
617: SELECT gph.*
618: FROM ghr_addresses_h_v gph
619: WHERE gph.person_id = cp_person_id
620: AND gph.address_type='M'
621: AND gph.business_group_id = g_business_group_id
622: AND gph.effective_date <= cp_ext_end_date