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.BEN_ENROLLMENT_ACTION_ITEMS dependencies on PER_ADDRESSES

Line 2701: from per_addresses peradd,

2697: cursor c_prtt_adrs is
2698: select peradd.primary_flag,
2699: peradd.address_line1,
2700: peradd.postal_code
2701: from per_addresses peradd,
2702: ben_prtt_enrt_rslt_f perslt
2703: where perslt.prtt_enrt_rslt_id = p_prtt_enrt_rslt_id
2704: and perslt.person_id = peradd.person_id
2705: and peradd.business_group_id = p_business_group_id

Line 2722: from per_addresses peradd

2718: cursor c_dpnt_bnf_adrs is
2719: select peradd.primary_flag,
2720: peradd.address_line1,
2721: peradd.postal_code
2722: from per_addresses peradd
2723: where peradd.person_id = p_dpnt_bnf_person_id
2724: and peradd.business_group_id = p_business_group_id
2725: and p_effective_date between peradd.date_from and
2726: nvl(peradd.date_to,p_effective_date)

Line 2733: from per_addresses peradd

2729: /* cursor c_dpnt_bnf_adrs is
2730: select peradd.primary_flag,
2731: peradd.address_line1,
2732: peradd.postal_code
2733: from per_addresses peradd
2734: where peradd.person_id = p_dpnt_bnf_person_id
2735: and peradd.business_group_id = p_business_group_id; */
2736: --
2737: l_dpnt_bnf_adrs c_dpnt_bnf_adrs%rowtype;