APPS.GL_FUSION_TRANSFER_PKG dependencies on GL_XFR_PERIODS

Line 724: gl_xfr_periods per

720: UPDATE gl_xfr_led_map_periods lmper
721: SET temp_date = (SELECT least(greatest(trunc(sysdate),per.start_date),per.end_date)
722: FROM gl_xfr_period_mappings map,
723: gl_xfr_ledgers lgr,
724: gl_xfr_periods per
725: WHERE map.calendar_mapping_id = g_cal_mapping_id
726: AND map.from_period_name = lmper.from_period_name
727: AND lgr.ledger_id = g_to_ledger_id
728: AND per.period_set_name = lgr.period_set_name

Line 745: gl_xfr_periods per

741: SELECT to_number(to_char(least(greatest(trunc(sysdate),per.start_date),per.end_date),'J'))
742: INTO l_eff_date
743: FROM gl_xfr_period_mappings map,
744: gl_xfr_ledgers lgr,
745: gl_xfr_periods per
746: WHERE map.calendar_mapping_id = g_cal_mapping_id
747: AND map.from_period_name = g_from_period
748: AND lgr.ledger_id = g_to_ledger_id
749: AND per.period_set_name = lgr.period_set_name

Line 1810: FROM gl_xfr_ledgers lgr, gl_xfr_periods per

1806: ELSE
1807: BEGIN
1808: SELECT period_name
1809: INTO g_to_period
1810: FROM gl_xfr_ledgers lgr, gl_xfr_periods per
1811: WHERE lgr.ledger_id = g_to_ledger_id
1812: AND per.period_set_name = lgr.period_set_name
1813: AND per.period_type = lgr.accounted_period_type
1814: AND per.period_name = g_from_period;