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_ASSIGNMENT_INTERNAL dependencies on PER_ADDRESSES

Line 22: l_add_dets per_addresses%ROWTYPE;

18: ,p_date in date default null
19: )
20: is
21: --
22: l_add_dets per_addresses%ROWTYPE;
23: --
24: l_ctr_shdresflg varchar2(100);
25: l_ctr_id number;
26: l_ctr_ovn number;

Line 48: from per_addresses adr

44: (c_per_id in number
45: )
46: Is
47: select *
48: from per_addresses adr
49: where adr.person_id = c_per_id
50: and adr.primary_flag = 'Y'
51: and p_benasg_effdate between adr.date_from and nvl(adr.date_to,p_benasg_effdate)
52: order by adr.date_from desc ;

Line 61: from per_addresses adr

57: (c_per_id in number
58: )
59: Is
60: select min(date_from)
61: from per_addresses adr
62: where adr.person_id = c_per_id
63: and adr.primary_flag = 'Y'
64: and adr.date_from > p_benasg_effdate;
65:

Line 2022: from per_addresses adr

2018: (c_per_id in number
2019: )
2020: Is
2021: select 'Y'
2022: from per_addresses adr
2023: where adr.person_id = c_per_id
2024: and adr.primary_flag = 'Y'
2025: and p_effective_date between adr.date_from and nvl(adr.date_to,p_effective_date)
2026: order by adr.date_from desc ;

Line 2033: from per_addresses adr

2029: (c_per_id in number
2030: )
2031: Is
2032: select *
2033: from per_addresses adr
2034: where adr.person_id = c_per_id
2035: and adr.primary_flag = 'Y'
2036: order by adr.date_from desc ;
2037: