DBA Data[Home] [Help]

APPS.FUN_GL_TRANSFER dependencies on GL_PERIOD_STATUSES

Line 156: gl_period_statuses ps

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

Line 168: FROM gl_period_statuses ps

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