DBA Data[Home] [Help]

APPS.POA_DBI_SAVINGS_PKG dependencies on POA_GA_UTIL_PKG

Line 190: l_ga_conversion_rate := nvl(l_pbline.bl_rate, 1) * poa_ga_util_pkg.get_ga_conversion_rate(l_pbline.bl_func_cur_code, p_func_cur_code, p_rate_date); -- convert to blanket functional currency and then to standard PO functional currency

186: loop
187: fetch pblines_cur into l_pbline;
188: exit when pblines_cur%NOTFOUND;
189:
190: l_ga_conversion_rate := nvl(l_pbline.bl_rate, 1) * poa_ga_util_pkg.get_ga_conversion_rate(l_pbline.bl_func_cur_code, p_func_cur_code, p_rate_date); -- convert to blanket functional currency and then to standard PO functional currency
191:
192: if(l_pbline.global_agreement_flag = 'Y') then
193: select
194: sum(case when sll.approved_flag='Y' and sll.ship_to_location_id=p_ship_to_location_id then nvl(sd.quantity_ordered,0)-nvl(sd.quantity_cancelled,0) else 0 end) line_qty