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.HRI_OPL_WRKFC_EVENTS dependencies on FII_TIME_MONTH

Line 294: ,fii_time_month mnth

290: ,wevt.contingent_ind
291: ,wevt.adt_pow_band
292: FROM
293: hri_mb_wrkfc_evt_ct wevt
294: ,fii_time_month mnth
295: WHERE mnth.end_date BETWEEN wevt.time_day_evt_fk
296: AND wevt.time_day_evt_end_fk
297: -- If assignment is ended, only snapshot the ended assignment once
298: AND ((wevt.worker_term_ind = 0 AND wevt.pre_sprtn_asgn_end_ind = 0)

Line 502: ,fii_time_month mnth

498: END last_month_in_year_ind
499: ,0 zero_row_ind
500: FROM
501: hri_mb_wrkfc_evt_ct wevt
502: ,fii_time_month mnth
503: WHERE wevt.time_day_evt_fk <= mnth.end_date
504: AND mnth.start_date <= wevt.time_day_evt_end_fk
505: -- If assignment is ended, only snapshot the ended assignment once
506: AND ((wevt.worker_term_ind = 0 AND wevt.pre_sprtn_asgn_end_ind = 0)

Line 573: ,fii_time_month mnth

569: END last_month_in_year_ind
570: ,1 zero_row_ind
571: FROM
572: hri_mb_wrkfc_evt_ct wevt
573: ,fii_time_month mnth
574: WHERE mnth.end_date BETWEEN wevt.time_day_evt_fk
575: AND wevt.time_day_evt_end_fk
576: -- If assignment is ended, no need to snapshot
577: AND wevt.worker_term_ind = 0

Line 854: ,fii_time_month mnth

850: ,eq.erlst_evnt_effective_date adt_event_date
851: FROM
852: hri_eq_wrkfc_mnth eq
853: ,hri_mb_wrkfc_evt_ct wevt
854: ,fii_time_month mnth
855: WHERE eq.assignment_id = wevt.asg_assgnmnt_fk
856: AND mnth.end_date BETWEEN wevt.time_day_evt_fk
857: AND wevt.time_day_evt_end_fk
858: -- Snapshot previous value for zero record

Line 1066: ,fii_time_month mnth

1062: ,0 zero_row_ind
1063: FROM
1064: hri_eq_wrkfc_mnth eq
1065: ,hri_mb_wrkfc_evt_ct wevt
1066: ,fii_time_month mnth
1067: WHERE eq.assignment_id = wevt.asg_assgnmnt_fk
1068: AND mnth.end_date >= ADD_MONTHS(eq.erlst_evnt_effective_date, -1)
1069: AND wevt.time_day_evt_fk <= mnth.end_date
1070: AND mnth.start_date <= wevt.time_day_evt_end_fk

Line 1140: ,fii_time_month mnth

1136: ,1 zero_row_ind
1137: FROM
1138: hri_eq_wrkfc_mnth eq
1139: ,hri_mb_wrkfc_evt_ct wevt
1140: ,fii_time_month mnth
1141: WHERE eq.assignment_id = wevt.asg_assgnmnt_fk
1142: AND mnth.end_date BETWEEN wevt.time_day_evt_fk
1143: AND wevt.time_day_evt_end_fk
1144: -- Include month of change and the previous month (to zero out)