APPS.FUN_GL_TRANSFER dependencies on GL_PERIOD_STATUSES

Line 155: gl_period_statuses ps

151: /*SELECT ps.closing_status
152: INTO l_status
153: FROM gl_periods p,
154: gl_ledgers l,
155: gl_period_statuses ps
156: WHERE l.ledger_id = p_ledger_id AND
157: p.period_set_name = l.period_set_name AND
158: p_date BETWEEN p.start_date AND p.end_date AND
159: ps.period_name = p.period_name AND

Line 167: FROM gl_period_statuses ps

163: /* Bug 6707980 added ps.adjustment_period_flag = 'N' where claus */
164:
165: SELECT ps.closing_status
166: INTO l_status
167: FROM gl_period_statuses ps
168: WHERE ps.ledger_id = p_ledger_id AND
169: p_date BETWEEN ps.start_date AND ps.end_date AND
170: ps.application_id = p_app_id AND
171: ps.adjustment_period_flag = 'N';