APPS.GL_GLXRCTRS_XMLP_PKG dependencies on GL_PERIOD_STATUSES

Line 98: FROM gl_period_statuses

94:
95: If (P_PERIOD_FROM is not null AND P_PERIOD_TO is not null) THEN
96: SELECT start_date, effective_period_num
97: INTO cp_period_start, cp_eff_period_start
98: FROM gl_period_statuses
99: WHERE application_id =101
100: AND closing_status in ('C', 'O', 'P')
101: AND ledger_id = P_LEDGER_ID
102: and period_name = P_PERIOD_FROM;

Line 106: FROM gl_period_statuses

102: and period_name = P_PERIOD_FROM;
103:
104: SELECT end_date,effective_period_num
105: INTO cp_period_end,cp_eff_period_end
106: FROM gl_period_statuses
107: WHERE application_id = 101
108: AND closing_status in ('C', 'O', 'P')
109: AND ledger_id = P_LEDGER_ID
110: AND period_name = P_PERIOD_TO ;