117: WHERE application_id = 222
118: -- BEGIN abindal bug 4356410 --
119: AND closing_status IN ('F','O')
120: -- END abindal bug 4356410 --
121: AND ledger_id = okl_accounting_util.get_set_of_books_id
122: AND trunc(cp_date) between start_date and end_date
123: AND adjustment_period_flag = 'N'
124: UNION
125: SELECT MAX(end_date) gl_date, 2 Counter
124: UNION
125: SELECT MAX(end_date) gl_date, 2 Counter
126: FROM gl_period_statuses
127: WHERE application_id = 222
128: AND ledger_id = okl_accounting_util.get_set_of_books_id
129: AND closing_status IN ('F','O')
130: AND end_date <= trunc(cp_date)
131: AND adjustment_period_flag = 'N'
132: UNION
132: UNION
133: SELECT MIN(start_date) gl_date, 3 Counter
134: FROM gl_period_statuses
135: WHERE application_id = 222
136: AND ledger_id = okl_accounting_util.get_set_of_books_id
137: AND closing_status IN ('F','O')
138: AND start_date >= trunc(cp_date)
139: AND adjustment_period_flag = 'N'
140: )
328: l_applied_amount_from := NULL;
329: ELSE
330: l_applied_amount := lp_xcav_tbl(i).amount_applied;
331: -- Convert receipt currency to invoice currency if different
332: l_conversion_rate := okl_accounting_util.get_curr_con_rate
333: ( l_receipt_currency_code
334: ,l_trans_currency_code
335: ,trunc(SYSDATE)
336: ,'Corporate'
776: l_applied_amount_from := NULL;
777: ELSE
778: l_applied_amount := lp_xcav_tbl(i).amount_applied;
779: -- Convert receipt currency to invoice currency if different
780: l_conversion_rate := okl_accounting_util.get_curr_con_rate
781: ( l_receipt_currency
782: ,l_trans_currency_code
783: ,trunc(SYSDATE)
784: ,'Corporate'