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.

[Home] [Help]

APPS.PAY_NL_ABP_ARCHIVE dependencies on BEN_EXT_CHG_EVT_LOG

Line 139: FROM ben_ext_chg_evt_log

135: ,c_start_date IN DATE
136: ,c_end_date IN DATE) IS
137: SELECT old_val1 old_date
138: ,new_val1 new_date
139: FROM ben_ext_chg_evt_log
140: WHERE person_id = c_person_id
141: AND chg_evt_cd = 'COPOS'
142: AND fnd_date.canonical_to_date (prmtr_09) BETWEEN c_start_date
143: AND c_end_date

Line 3207: FROM ben_ext_chg_evt_log evt

3203: SELECT distinct last_day (add_months (start_date, level-1)) date_earned
3204: FROM (
3205: SELECT fnd_date.canonical_to_date (evt.prmtr_01) start_date
3206: , fnd_date.canonical_to_date (NVL(evt.prmtr_02,evt.prmtr_09)) end_date
3207: FROM ben_ext_chg_evt_log evt
3208: WHERE evt.prmtr_10 = to_char (c_assignment_id)
3209: AND evt.person_id = c_person_id
3210: AND evt.chg_evt_cd = 'COAPKOP'
3211: AND fnd_date.canonical_to_date (evt.prmtr_09)

Line 3222: FROM ben_ext_chg_evt_log evt

3218: SELECT DISTINCT last_day (add_months (start_date, level - 1)) date_earned
3219: FROM (
3220: SELECT fnd_date.canonical_to_date (evt.prmtr_02) start_date
3221: , last_day (c_end_date) end_date
3222: FROM ben_ext_chg_evt_log evt
3223: WHERE evt.ext_chg_evt_log_id =
3224: (
3225: SELECT max (ext_chg_evt_log_id)
3226: FROM ben_ext_chg_evt_log evt

Line 3226: FROM ben_ext_chg_evt_log evt

3222: FROM ben_ext_chg_evt_log evt
3223: WHERE evt.ext_chg_evt_log_id =
3224: (
3225: SELECT max (ext_chg_evt_log_id)
3226: FROM ben_ext_chg_evt_log evt
3227: WHERE evt.prmtr_01 = to_char (c_assignment_id)
3228: AND evt.person_id = c_person_id
3229: AND evt.chg_evt_cd = 'COAPS'
3230: AND fnd_date.canonical_to_date (evt.prmtr_02) <= last_day (c_end_date)

Line 3246: FROM ben_ext_chg_evt_log evt

3242: trunc (add_months (start_date, level - 1), 'MM') date_earned
3243: FROM (
3244: SELECT evt.old_val1 start_date
3245: , evt1.new_val1 end_date
3246: FROM ben_ext_chg_evt_log evt
3247: , ben_ext_chg_evt_log evt1
3248: ,
3249: (
3250: SELECT min (ext_chg_evt_log_id) min_chg_evt_log_id

Line 3247: , ben_ext_chg_evt_log evt1

3243: FROM (
3244: SELECT evt.old_val1 start_date
3245: , evt1.new_val1 end_date
3246: FROM ben_ext_chg_evt_log evt
3247: , ben_ext_chg_evt_log evt1
3248: ,
3249: (
3250: SELECT min (ext_chg_evt_log_id) min_chg_evt_log_id
3251: , max (ext_chg_evt_log_id) max_chg_evt_log_id

Line 3252: FROM ben_ext_chg_evt_log evt

3248: ,
3249: (
3250: SELECT min (ext_chg_evt_log_id) min_chg_evt_log_id
3251: , max (ext_chg_evt_log_id) max_chg_evt_log_id
3252: FROM ben_ext_chg_evt_log evt
3253: WHERE evt.person_id = c_person_id
3254: AND evt.chg_evt_cd = 'COPOS'
3255: AND fnd_date.canonical_to_date (evt.prmtr_09)
3256: BETWEEN c_start_date