APPS.GL_GLRGNJ_XMLP_PKG dependencies on GL_PERIOD_STATUSES

Line 149: FROM gl_period_statuses a,

145: IF (p_period_name IS NULL AND (p_start_date IS NULL OR p_end_date IS NULL)) THEN
146: IF (p_ledger_id is null) THEN
147: SELECT min(a.start_date),max(a.end_date)
148: INTO t_p_start_date, t_p_end_date
149: FROM gl_period_statuses a,
150: gl_access_set_assignments b
151: WHERE b.access_set_id = p_access_set_id
152: AND a.application_id = 101
153: AND a.closing_status <> 'N'

Line 158: FROM gl_period_statuses a,

154: AND a.ledger_id = b.ledger_id;
155: ELSIF (p_ledger_id is not null and param_ledger_type = 'S') THEN
156: SELECT min(a.start_date),max(a.end_date)
157: INTO t_p_start_date, t_p_end_date
158: FROM gl_period_statuses a,
159: gl_ledger_set_assignments b
160: WHERE b.ledger_set_id = p_ledger_id
161: AND a.application_id = 101
162: AND a.closing_status <> 'N'

Line 167: FROM gl_period_statuses

163: AND a.ledger_id = b.ledger_id;
164: ELSE
165: SELECT min(start_date),max(end_date)
166: INTO t_p_start_date, t_p_end_date
167: FROM gl_period_statuses
168: WHERE application_id = 101
169: AND ledger_id = p_ledger_id
170: AND closing_status <> 'N';
171: END IF;