DBA Data[Home] [Help]

APPS.ZX_EXTRACT_PKG dependencies on GL_PERIOD_STATUSES

Line 1283: FROM gl_period_statuses

1279: P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_LOW IS NULL THEN
1280:
1281: SELECT start_date
1282: INTO p_trl_global_variables_rec.gl_date_low
1283: FROM gl_period_statuses
1284: WHERE upper(period_name) = upper(p_trl_global_variables_rec.gl_period_name_low)
1285: AND set_of_books_id = g_ledger_id
1286: AND application_id = 101;
1287:

Line 1301: FROM gl_period_statuses

1297: AND P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_HIGH IS NULL THEN
1298:
1299: SELECT end_date
1300: INTO p_trl_global_variables_rec.gl_date_high
1301: FROM gl_period_statuses
1302: WHERE upper(period_name) = upper(p_trl_global_variables_rec.gl_period_name_high)
1303: AND set_of_books_id = g_ledger_id
1304: AND application_id = 101;
1305:

Line 1342: FROM gl_period_statuses

1338: AND P_TRL_GLOBAL_VARIABLES_REC.TRX_DATE_LOW IS NULL THEN
1339:
1340: SELECT start_date
1341: INTO p_trl_global_variables_rec.trx_date_low
1342: FROM gl_period_statuses
1343: WHERE period_name = p_trl_global_variables_rec.trx_date_period_name_low
1344: AND set_of_books_id = g_ledger_id
1345: AND application_id = 101;
1346:

Line 1354: FROM gl_period_statuses

1350: AND P_TRL_GLOBAL_VARIABLES_REC.TRX_DATE_HIGH IS NULL THEN
1351:
1352: SELECT end_date
1353: INTO p_trl_global_variables_rec.trx_date_high
1354: FROM gl_period_statuses
1355: WHERE period_name = p_trl_global_variables_rec.trx_date_period_name_high
1356: AND set_of_books_id = g_ledger_id
1357: AND application_id = 101;
1358: