DBA Data[Home] [Help]

APPS.OKL_BPD_MAN_RCT_HANDLE_PVT dependencies on OKL_ACCOUNTING_UTIL

Line 121: AND ledger_id = okl_accounting_util.get_set_of_books_id

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

Line 128: AND ledger_id = okl_accounting_util.get_set_of_books_id

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

Line 136: AND ledger_id = okl_accounting_util.get_set_of_books_id

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: )

Line 332: l_conversion_rate := okl_accounting_util.get_curr_con_rate

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'

Line 780: l_conversion_rate := okl_accounting_util.get_curr_con_rate

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'