APPS.GL_FUSION_TRANSFER_PKG dependencies on GL_PERIOD_STATUSES

Line 714: FROM gl_period_statuses ps

710: IF (g_transfer_mode = C_INCREMENTAL) THEN
711: IF (g_cal_mapping_id IS NULL) THEN
712: UPDATE gl_xfr_led_map_periods lmper
713: SET temp_date = (SELECT least(greatest(trunc(sysdate),ps.start_date),ps.end_date)
714: FROM gl_period_statuses ps
715: WHERE ps.application_id = 101
716: AND ps.ledger_id = g_from_ledger_id
717: AND ps.period_name = lmper.from_period_name)
718: WHERE ledger_mapping_id = g_lgr_mapping_id;

Line 736: FROM gl_period_statuses ps

732: ELSE
733: IF (g_cal_mapping_id IS NULL) THEN
734: SELECT to_number(to_char(least(greatest(trunc(sysdate),ps.start_date),ps.end_date),'J'))
735: INTO l_eff_date
736: FROM gl_period_statuses ps
737: WHERE ps.application_id = 101
738: AND ps.ledger_id = g_from_ledger_id
739: AND ps.period_name = g_from_period;
740: ELSE

Line 775: FROM gl_period_statuses

771: g_first_period_changed := TRUE;
772:
773: SELECT period_name
774: INTO g_original_first_period
775: FROM gl_period_statuses
776: WHERE application_id = 101
777: AND ledger_id = g_from_ledger_id
778: AND effective_period_num = g_first_eff_per_num;
779:

Line 1775: FROM gl_period_statuses

1771: ---
1772: IF (g_transfer_mode = C_FULL) THEN
1773: SELECT effective_period_num
1774: INTO g_from_eff_per_num
1775: FROM gl_period_statuses
1776: WHERE application_id = 101
1777: AND ledger_id = g_from_ledger_id
1778: AND period_name = g_from_period;
1779: