66: AND cbagv.bank_account_id = P_BANK_ACCOUNT_ID;
67:
68: SELECT glp.start_date
69: INTO gc_from_date
70: FROM gl_period_statuses glp
71: WHERE glp.application_id = 101
72: AND glp.period_name = P_ACC_PERIOD_FROM
73: AND glp.set_of_books_id = gn_sob_id;
74:
73: AND glp.set_of_books_id = gn_sob_id;
74:
75: SELECT glp.end_date
76: INTO gc_to_date
77: FROM gl_period_statuses glp
78: WHERE glp.application_id = 101
79: AND glp.period_name = P_ACC_PERIOD_TO
80: AND glp.set_of_books_id = gn_sob_id;
81: