DBA Data[Home] [Help]

APPS.HRI_OPL_WRKFC_EVT_MGRH dependencies on FII_TIME_MONTH

Line 763: FROM fii_time_month month

759: month.month_id
760: ,add_months(to_date(SUBSTR(to_char(month.month_id), 1, 4) || '-' ||
761: SUBSTR(to_char(month.month_id), 6, 2), 'YYYY-MM'),
762: 1) - 1 end_date
763: FROM fii_time_month month
764: ) mnth
765: WHERE mnth.month_id >= to_number(to_char(g_dbi_start_date, 'YYYYQMM'))
766: AND mnth.month_id <= to_number(to_char(g_sysdate, 'YYYYQMM'))
767: AND mgr.mgrs_level = p_mthd_range_lvl

Line 812: FROM fii_time_month month

808: month.month_id
809: ,add_months(to_date(SUBSTR(to_char(month.month_id), 1, 4) || '-' ||
810: SUBSTR(to_char(month.month_id), 6, 2), 'YYYY-MM'),
811: 1) - 1 end_date
812: FROM fii_time_month month
813: ) mnth
814: WHERE eq.sup_person_id BETWEEN p_start_object_id
815: AND p_end_object_id
816: AND eq.sup_person_id = mgr.mgrs_person_fk