37: --26
38: v_net_total_amt_goals varchar2(14);
39: v_net_total_amt number;
40:
41: v_set_of_books_id gl_ledgers_public_v.ledger_id%TYPE;
42:
43: -- v_98 varchar2(14);
44: -- v_99 varchar2(14);
45:
276: vp_alc := p_alc;
277:
278: SELECT chart_of_accounts_id
279: INTO flex_num
280: FROM gl_ledgers_public_v
281: WHERE ledger_id = v_set_of_books_id;
282:
283: SELECT distinct period_type
284: INTO statuses_period_type
290: TRUNC(end_date)+1
291: INTO v_reporting_date,
292: v_end_date
293: FROM gl_periods glp,
294: gl_ledgers_public_v gsob
295: WHERE glp.period_name = gl_period_name
296: AND glp.period_type = statuses_period_type
297: AND gsob.ledger_id = v_set_of_books_id
298: AND gsob.chart_of_accounts_id = flex_num