APPS.GL_FUSION_TRANSFER_PKG dependencies on GL_XFR_LEDGERS

Line 723: gl_xfr_ledgers lgr,

719: ELSE
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

Line 744: gl_xfr_ledgers lgr,

740: ELSE
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

Line 1733: gl_xfr_ledgers tlgr

1729: g_first_eff_per_num, g_to_coa_id,
1730: g_cal_mapping_id, g_to_ledger_name
1731: FROM gl_xfr_ledger_mappings lgr,
1732: gl_coa_mappings map,
1733: gl_xfr_ledgers tlgr
1734: WHERE lgr.from_ledger_id = g_from_ledger_id
1735: AND lgr.from_ledger_currency = g_funct_curr
1736: AND map.coa_mapping_id(+) = lgr.coa_mapping_id
1737: AND tlgr.ledger_id = lgr.to_ledger_id;

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;

Line 2204: FROM gl_xfr_ledgers

2200: --- Get balancing segment column
2201: ---
2202: SELECT bal_seg_column_name
2203: INTO l_bsv_column
2204: FROM gl_xfr_ledgers
2205: WHERE ledger_id = g_to_ledger_id;
2206:
2207: ---
2208: --- Build sql*statement