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_EXT_PERSON dependencies on HR_API

Line 93: if l_from_date is not null and l_from_date <> hr_api.g_sot then

89: if i.crit_typ_cd = 'CAD' then
90: l_cad_exist := 'Y' ;
91: -- calc the cad from and to date
92: -- get the lowest from date and highetst to date excluding eof and bof
93: if l_from_date is not null and l_from_date <> hr_api.g_sot then
94: if nvl(l_act_from_dt,hr_api.g_eot) > l_from_date then
95: l_act_from_dt := l_from_date ;
96: end if ;
97:

Line 94: if nvl(l_act_from_dt,hr_api.g_eot) > l_from_date then

90: l_cad_exist := 'Y' ;
91: -- calc the cad from and to date
92: -- get the lowest from date and highetst to date excluding eof and bof
93: if l_from_date is not null and l_from_date <> hr_api.g_sot then
94: if nvl(l_act_from_dt,hr_api.g_eot) > l_from_date then
95: l_act_from_dt := l_from_date ;
96: end if ;
97:
98: end if ;

Line 101: if l_to_date is not null and l_to_date <> hr_api.g_eot then

97:
98: end if ;
99:
100:
101: if l_to_date is not null and l_to_date <> hr_api.g_eot then
102: if nvl(l_act_to_dt,hr_api.g_sot) < l_to_date then
103: l_act_to_dt := l_to_date ;
104: end if ;
105: end if ;

Line 102: if nvl(l_act_to_dt,hr_api.g_sot) < l_to_date then

98: end if ;
99:
100:
101: if l_to_date is not null and l_to_date <> hr_api.g_eot then
102: if nvl(l_act_to_dt,hr_api.g_sot) < l_to_date then
103: l_act_to_dt := l_to_date ;
104: end if ;
105: end if ;
106:

Line 114: if l_from_date is not null and l_from_date <> hr_api.g_sot then

110: else
111: l_ced_exist := 'Y' ;
112: -- calc the cad from and to date
113: -- get the lowest from date and highetst to date excluding eof and bof
114: if l_from_date is not null and l_from_date <> hr_api.g_sot then
115: if nvl(l_eff_from_dt,hr_api.g_eot) > l_from_date then
116: l_eff_from_dt := l_from_date ;
117: end if ;
118:

Line 115: if nvl(l_eff_from_dt,hr_api.g_eot) > l_from_date then

111: l_ced_exist := 'Y' ;
112: -- calc the cad from and to date
113: -- get the lowest from date and highetst to date excluding eof and bof
114: if l_from_date is not null and l_from_date <> hr_api.g_sot then
115: if nvl(l_eff_from_dt,hr_api.g_eot) > l_from_date then
116: l_eff_from_dt := l_from_date ;
117: end if ;
118:
119: end if ;

Line 122: if l_to_date is not null and l_to_date <> hr_api.g_eot then

118:
119: end if ;
120:
121:
122: if l_to_date is not null and l_to_date <> hr_api.g_eot then
123: if nvl(l_eff_to_dt,hr_api.g_sot) < l_to_date then
124: l_eff_to_dt := l_to_date ;
125: end if ;
126: end if ;

Line 123: if nvl(l_eff_to_dt,hr_api.g_sot) < l_to_date then

119: end if ;
120:
121:
122: if l_to_date is not null and l_to_date <> hr_api.g_eot then
123: if nvl(l_eff_to_dt,hr_api.g_sot) < l_to_date then
124: l_eff_to_dt := l_to_date ;
125: end if ;
126: end if ;
127:

Line 137: l_act_from_dt := hr_api.g_sot ;

133: --- if the dates are bot and eot return there is not point in
134: --- executing the interpreter twice when one more is bot and eot
135: if l_cad_exist = 'Y' then
136: if l_act_from_dt is null then
137: l_act_from_dt := hr_api.g_sot ;
138: end if ;
139:
140: if l_act_to_dt is null then
141: l_act_to_dt := hr_api.g_eot ;

Line 141: l_act_to_dt := hr_api.g_eot ;

137: l_act_from_dt := hr_api.g_sot ;
138: end if ;
139:
140: if l_act_to_dt is null then
141: l_act_to_dt := hr_api.g_eot ;
142: end if ;
143:
144: if l_act_from_dt = hr_api.g_sot and l_act_to_dt = hr_api.g_eot then
145: p_act_from_dt := l_act_from_dt;

Line 144: if l_act_from_dt = hr_api.g_sot and l_act_to_dt = hr_api.g_eot then

140: if l_act_to_dt is null then
141: l_act_to_dt := hr_api.g_eot ;
142: end if ;
143:
144: if l_act_from_dt = hr_api.g_sot and l_act_to_dt = hr_api.g_eot then
145: p_act_from_dt := l_act_from_dt;
146: p_act_to_dt := l_act_to_dt ;
147: p_date_mode := 'C' ;
148:

Line 175: l_eff_from_dt := hr_api.g_sot ;

171:
172: if l_ced_exist = 'Y' then
173:
174: if l_eff_from_dt is null then
175: l_eff_from_dt := hr_api.g_sot ;
176: end if ;
177:
178: if l_eff_to_dt is null then
179: l_eff_to_dt := hr_api.g_eot ;

Line 179: l_eff_to_dt := hr_api.g_eot ;

175: l_eff_from_dt := hr_api.g_sot ;
176: end if ;
177:
178: if l_eff_to_dt is null then
179: l_eff_to_dt := hr_api.g_eot ;
180: end if ;
181:
182: if l_eff_from_dt = hr_api.g_sot and l_eff_to_dt = hr_api.g_eot then
183: p_eff_from_dt := l_eff_from_dt;

Line 182: if l_eff_from_dt = hr_api.g_sot and l_eff_to_dt = hr_api.g_eot then

178: if l_eff_to_dt is null then
179: l_eff_to_dt := hr_api.g_eot ;
180: end if ;
181:
182: if l_eff_from_dt = hr_api.g_sot and l_eff_to_dt = hr_api.g_eot then
183: p_eff_from_dt := l_eff_from_dt;
184: p_eff_to_dt := l_eff_to_dt ;
185: p_date_mode := 'E' ;
186:

Line 2622: and trunc(a.chg_actl_dt) between nvl(p_chg_actl_strt_dt, hr_api.g_sot)

2618: , 'BEN' chg_evt_source
2619: from ben_ext_chg_evt_log a
2620: where
2621: a.person_id = p_person_id
2622: and trunc(a.chg_actl_dt) between nvl(p_chg_actl_strt_dt, hr_api.g_sot)
2623: and nvl(p_chg_actl_end_dt, hr_api.g_eot)
2624: and a.chg_eff_dt between nvl(p_chg_eff_strt_dt, hr_api.g_sot)
2625: and nvl(p_chg_eff_end_dt, hr_api.g_eot)
2626: order by a.chg_eff_dt;

Line 2623: and nvl(p_chg_actl_end_dt, hr_api.g_eot)

2619: from ben_ext_chg_evt_log a
2620: where
2621: a.person_id = p_person_id
2622: and trunc(a.chg_actl_dt) between nvl(p_chg_actl_strt_dt, hr_api.g_sot)
2623: and nvl(p_chg_actl_end_dt, hr_api.g_eot)
2624: and a.chg_eff_dt between nvl(p_chg_eff_strt_dt, hr_api.g_sot)
2625: and nvl(p_chg_eff_end_dt, hr_api.g_eot)
2626: order by a.chg_eff_dt;
2627:

Line 2624: and a.chg_eff_dt between nvl(p_chg_eff_strt_dt, hr_api.g_sot)

2620: where
2621: a.person_id = p_person_id
2622: and trunc(a.chg_actl_dt) between nvl(p_chg_actl_strt_dt, hr_api.g_sot)
2623: and nvl(p_chg_actl_end_dt, hr_api.g_eot)
2624: and a.chg_eff_dt between nvl(p_chg_eff_strt_dt, hr_api.g_sot)
2625: and nvl(p_chg_eff_end_dt, hr_api.g_eot)
2626: order by a.chg_eff_dt;
2627:
2628:

Line 2625: and nvl(p_chg_eff_end_dt, hr_api.g_eot)

2621: a.person_id = p_person_id
2622: and trunc(a.chg_actl_dt) between nvl(p_chg_actl_strt_dt, hr_api.g_sot)
2623: and nvl(p_chg_actl_end_dt, hr_api.g_eot)
2624: and a.chg_eff_dt between nvl(p_chg_eff_strt_dt, hr_api.g_sot)
2625: and nvl(p_chg_eff_end_dt, hr_api.g_eot)
2626: order by a.chg_eff_dt;
2627:
2628:
2629:

Line 2705: and nvl(b.to_be_sent_dt,hr_api.g_sot) between nvl(p_to_be_sent_strt_dt, hr_api.g_sot)

2701: and a.per_in_ler_id = p.per_in_ler_id(+)
2702: and p.ler_id = l.ler_id(+)
2703: and b.per_cm_prvdd_stat_cd = 'ACTIVE' -- this should be inclusion criteria.
2704: -- the following line of code was put here for performance.
2705: and nvl(b.to_be_sent_dt,hr_api.g_sot) between nvl(p_to_be_sent_strt_dt, hr_api.g_sot)
2706: and nvl(p_to_be_sent_end_dt, hr_api.g_eot)
2707: and p_effective_date between b.effective_start_date
2708: and b.effective_end_date
2709: and b.effective_start_date between a.effective_start_date

Line 2706: and nvl(p_to_be_sent_end_dt, hr_api.g_eot)

2702: and p.ler_id = l.ler_id(+)
2703: and b.per_cm_prvdd_stat_cd = 'ACTIVE' -- this should be inclusion criteria.
2704: -- the following line of code was put here for performance.
2705: and nvl(b.to_be_sent_dt,hr_api.g_sot) between nvl(p_to_be_sent_strt_dt, hr_api.g_sot)
2706: and nvl(p_to_be_sent_end_dt, hr_api.g_eot)
2707: and p_effective_date between b.effective_start_date
2708: and b.effective_end_date
2709: and b.effective_start_date between a.effective_start_date
2710: and a.effective_end_date

Line 2766: and nvl(b.to_be_sent_dt,hr_api.g_sot) between nvl(p_to_be_sent_strt_dt, hr_api.g_sot)

2762: a.person_id = p_person_id
2763: and a.per_cm_id = b.per_cm_id
2764: and b.per_cm_prvdd_stat_cd = 'ACTIVE' -- this should be inclusion criteria.
2765: -- the following line of code was put here for performance.
2766: and nvl(b.to_be_sent_dt,hr_api.g_sot) between nvl(p_to_be_sent_strt_dt, hr_api.g_sot)
2767: and nvl(p_to_be_sent_end_dt, hr_api.g_eot)
2768: and p_effective_date between b.effective_start_date
2769: and b.effective_end_date
2770: and b.effective_start_date between a.effective_start_date

Line 2767: and nvl(p_to_be_sent_end_dt, hr_api.g_eot)

2763: and a.per_cm_id = b.per_cm_id
2764: and b.per_cm_prvdd_stat_cd = 'ACTIVE' -- this should be inclusion criteria.
2765: -- the following line of code was put here for performance.
2766: and nvl(b.to_be_sent_dt,hr_api.g_sot) between nvl(p_to_be_sent_strt_dt, hr_api.g_sot)
2767: and nvl(p_to_be_sent_end_dt, hr_api.g_eot)
2768: and p_effective_date between b.effective_start_date
2769: and b.effective_end_date
2770: and b.effective_start_date between a.effective_start_date
2771: and a.effective_end_date