APPS.ZX_EXTRACT_PKG dependencies on GL_PERIOD_STATUSES

Line 1751: FROM gl_period_statuses

1747: P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_LOW IS NULL THEN
1748:
1749: SELECT start_date
1750: INTO p_trl_global_variables_rec.gl_date_low
1751: FROM gl_period_statuses
1752: WHERE upper(period_name) = upper(p_trl_global_variables_rec.gl_period_name_low)
1753: AND set_of_books_id = g_ledger_id
1754: AND application_id = 101;
1755:

Line 1769: FROM gl_period_statuses

1765: AND P_TRL_GLOBAL_VARIABLES_REC.GL_DATE_HIGH IS NULL THEN
1766:
1767: SELECT To_Date(To_Char(end_date,'DD-MM-YYYY')||' 23:59:59','DD-MM-YYYY HH24:MI:SS')
1768: INTO p_trl_global_variables_rec.gl_date_high
1769: FROM gl_period_statuses
1770: WHERE upper(period_name) = upper(p_trl_global_variables_rec.gl_period_name_high)
1771: AND set_of_books_id = g_ledger_id
1772: AND application_id = 101;
1773:

Line 1810: FROM gl_period_statuses

1806: AND P_TRL_GLOBAL_VARIABLES_REC.TRX_DATE_LOW IS NULL THEN
1807:
1808: SELECT start_date
1809: INTO p_trl_global_variables_rec.trx_date_low
1810: FROM gl_period_statuses
1811: WHERE period_name = p_trl_global_variables_rec.trx_date_period_name_low
1812: AND set_of_books_id = g_ledger_id
1813: AND application_id = 101;
1814:

Line 1822: FROM gl_period_statuses

1818: AND P_TRL_GLOBAL_VARIABLES_REC.TRX_DATE_HIGH IS NULL THEN
1819:
1820: SELECT end_date
1821: INTO p_trl_global_variables_rec.trx_date_high
1822: FROM gl_period_statuses
1823: WHERE period_name = p_trl_global_variables_rec.trx_date_period_name_high
1824: AND set_of_books_id = g_ledger_id
1825: AND application_id = 101;
1826: