APPS.GL_JE_HEADERS_PKG dependencies on GL_PERIOD_STATUSES

Line 153: from gl_period_statuses ps

149: accrual_rev_effective_date
150: = (select decode(jeh.accrual_rev_status,
151: null, ps.start_date,
152: jeh.accrual_rev_effective_date)
153: from gl_period_statuses ps
154: where ps.application_id = 101
155: and ps.ledger_id = jeh.ledger_id
156: and ps.period_name = jeh.accrual_rev_period_name)
157: WHERE je_batch_id = batch_id;

Line 777: gl_period_statuses_pkg.select_columns(

773: END;
774:
775: -- Get the period information
776: BEGIN
777: gl_period_statuses_pkg.select_columns(
778: 101,
779: ledger_id,
780: period_name,
781: closing_status,

Line 798: gl_period_statuses_pkg.select_columns(

794:
795: -- Get the reversing period information
796: IF (accrual_rev_period_name IS NOT NULL) THEN
797: BEGIN
798: gl_period_statuses_pkg.select_columns(
799: 101,
800: ledger_id,
801: accrual_rev_period_name,
802: tmp_closing_status,