[Home] [Help]
52:
53: begin
54: SELECT effective_period_num
55: INTO FROM_EFF_PERIOD_NUM
56: FROM gl_period_statuses
57: WHERE application_id = 101
58: AND ledger_id = P_LEDGER_ID
59: AND period_name = P_FROM_PERIOD;
60:
59: AND period_name = P_FROM_PERIOD;
60:
61: SELECT effective_period_num
62: INTO TO_EFF_PERIOD_NUM
63: FROM gl_period_statuses
64: WHERE application_id = 101
65: AND ledger_id = P_LEDGER_ID
66: AND period_name = P_TO_PERIOD;
67: exception