APPS.BIL_TX_UTIL_RPT_PKG dependencies on GL_PERIODS

Line 831: FROM gl_periods

827:
828: BEGIN
829:
830: SELECT period_name INTO l_period_name
831: FROM gl_periods
832: WHERE period_type = FND_PROFILE.VALUE('ASN_FRCST_DEFAULT_PERIOD_TYPE')
833: AND period_set_name = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR')
834: AND trunc(sysdate) >= start_date and trunc(sysdate) <= end_date;
835:

Line 942: -- Here logic is if record exists in gl_periods then pass date otherwise

938: END IF;
939:
940: END GET_DEFAULT_RPT_BY;
941:
942: -- Here logic is if record exists in gl_periods then pass date otherwise
943: -- we have to see how to make it work(for day)i.e.,
944: -- if it is not a week, month, quarter, year. not records does not exist in gl_periods
945:
946: FUNCTION GET_FROM_DATE (p_from_period_name IN VARCHAR2) RETURN DATE IS

Line 944: -- if it is not a week, month, quarter, year. not records does not exist in gl_periods

940: END GET_DEFAULT_RPT_BY;
941:
942: -- Here logic is if record exists in gl_periods then pass date otherwise
943: -- we have to see how to make it work(for day)i.e.,
944: -- if it is not a week, month, quarter, year. not records does not exist in gl_periods
945:
946: FUNCTION GET_FROM_DATE (p_from_period_name IN VARCHAR2) RETURN DATE IS
947: l_from_date DATE;
948: BEGIN

Line 954: FROM gl_periods

950:
951:
952: SELECT start_date
953: INTO l_from_date
954: FROM gl_periods
955: WHERE period_set_name = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR')
956: AND sysdate BETWEEN ADD_MONTHS(start_date, -6)
957: AND ADD_MONTHS(end_date, 6)
958: AND ADJUSTMENT_PERIOD_FLAG = 'N'

Line 1006: FROM gl_periods

1002: WHERE value = p_to_period_name;
1003: */
1004: SELECT end_date
1005: INTO l_to_date
1006: FROM gl_periods
1007: WHERE period_set_name = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR')
1008: AND sysdate BETWEEN ADD_MONTHS(start_date, -6)
1009: AND ADD_MONTHS(end_date, 6)
1010: AND ADJUSTMENT_PERIOD_FLAG = 'N'

Line 1176: FROM gl_periods

1172:
1173:
1174: SELECT start_date
1175: INTO l_start_date
1176: FROM gl_periods
1177: WHERE period_set_name = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR')
1178: AND sysdate BETWEEN ADD_MONTHS(start_date, -6)
1179: AND ADD_MONTHS(end_date, 6)
1180: AND ADJUSTMENT_PERIOD_FLAG = 'N'

Line 1198: FROM gl_periods

1194:
1195: SELECT PERIOD_YEAR||DECODE(LENGTH(QUARTER_NUM), 1, 0||QUARTER_NUM, QUARTER_NUM)||
1196: DECODE(LENGTH(PERIOD_NUM), 1, 0||PERIOD_NUM, PERIOD_NUM)
1197: INTO l_default_start_period_id
1198: FROM gl_periods
1199: WHERE period_set_name = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR')
1200: AND sysdate BETWEEN ADD_MONTHS(start_date, -6)
1201: AND ADD_MONTHS(end_date, 6)
1202: AND ADJUSTMENT_PERIOD_FLAG = 'N'

Line 1256: FROM gl_periods

1252: */
1253:
1254: SELECT end_date
1255: INTO l_end_date
1256: FROM gl_periods
1257: WHERE period_set_name = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR')
1258: AND sysdate BETWEEN ADD_MONTHS(start_date, -6)
1259: AND ADD_MONTHS(end_date, 6)
1260: AND ADJUSTMENT_PERIOD_FLAG = 'N'

Line 1276: FROM gl_periods

1272:
1273: SELECT PERIOD_YEAR||DECODE(LENGTH(QUARTER_NUM), 1, 0||QUARTER_NUM, QUARTER_NUM)||
1274: DECODE(LENGTH(PERIOD_NUM), 1, 0||PERIOD_NUM, PERIOD_NUM)
1275: INTO l_default_end_period_id
1276: FROM gl_periods
1277: WHERE period_set_name = FND_PROFILE.VALUE('ASN_FRCST_FORECAST_CALENDAR')
1278: AND sysdate BETWEEN ADD_MONTHS(start_date, -6)
1279: AND ADD_MONTHS(end_date, 6)
1280: AND ADJUSTMENT_PERIOD_FLAG = 'N'