APPS.GL_FUSION_TRANSFER_PKG dependencies on GL_XFR_PERIOD_MAPPINGS

Line 722: FROM gl_xfr_period_mappings map,

718: WHERE ledger_mapping_id = g_lgr_mapping_id;
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

Line 743: FROM gl_xfr_period_mappings map,

739: AND ps.period_name = g_from_period;
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

Line 1147: gl_xfr_period_mappings per, ';

1143: END IF;
1144:
1145: IF (g_cal_mapping_id IS NOT NULL) THEN
1146: l_sqlbuf := l_sqlbuf || '
1147: gl_xfr_period_mappings per, ';
1148: END IF;
1149:
1150: l_sqlbuf := l_sqlbuf || '
1151: gl_code_combinations cc

Line 1241: , gl_xfr_period_mappings per

1237: AND bal.period_name = :from_period_name
1238: AND bal.ledger_id = :from_ledger_id ';
1239: ELSE
1240: l_sqlbuf := l_sqlbuf || '
1241: , gl_xfr_period_mappings per
1242: WHERE per.calendar_mapping_id = :cal_mapping_id
1243: AND per.from_period_name = :from_period_name
1244: AND bal.ledger_id = :from_ledger_id
1245: AND bal.period_name = per.from_period_name ';

Line 1792: FROM gl_xfr_period_mappings

1788: IF (g_cal_mapping_id IS NOT NULL) THEN
1789: BEGIN
1790: SELECT to_period_name
1791: INTO g_to_period
1792: FROM gl_xfr_period_mappings
1793: WHERE calendar_mapping_id = g_cal_mapping_id
1794: AND from_period_name = g_from_period;
1795: EXCEPTION
1796: WHEN NO_DATA_FOUND THEN