APPS.GL_JE_HEADERS_PKG dependencies on GL_PERIOD_STATUSES

Line 151: from gl_period_statuses ps

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

Line 775: gl_period_statuses_pkg.select_columns(

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

Line 796: gl_period_statuses_pkg.select_columns(

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