APPS.POA_DBI_NEG_F_C dependencies on GL_SETS_OF_BOOKS

Line 67: l_global_cur_code gl_sets_of_books.currency_code%type;

63: d_glob_date DATE;
64: l_rate_type VARCHAR2(30);
65: l_srate_type VARCHAR2(30);
66: l_sec_cur_yn NUMBER;
67: l_global_cur_code gl_sets_of_books.currency_code%type;
68: l_sglobal_cur_code gl_sets_of_books.currency_code%type;
69: BEGIN
70: errbuf :=NULL;
71: retcode:=0;

Line 68: l_sglobal_cur_code gl_sets_of_books.currency_code%type;

64: l_rate_type VARCHAR2(30);
65: l_srate_type VARCHAR2(30);
66: l_sec_cur_yn NUMBER;
67: l_global_cur_code gl_sets_of_books.currency_code%type;
68: l_sglobal_cur_code gl_sets_of_books.currency_code%type;
69: BEGIN
70: errbuf :=NULL;
71: retcode:=0;
72: l_batch_size := bis_common_parameters.get_batch_size(10);

Line 161: gl_sets_of_books pgl,

157: nvl(trunc(ponh.rate_date),trunc(ponh.creation_date)) rate_date
158: FROM
159: pon_auction_headers_all ponh,
160: financials_system_params_all pfsp,
161: gl_sets_of_books pgl,
162: pon_auc_doctypes doctype
163: WHERE
164: ponh.auction_status = 'AUCTION_CLOSED'
165: and ponh.auction_type = 'REVERSE' /* Only Reverse (Buyer) auctions considered */

Line 195: gl_sets_of_books pgl,

191: nvl(trunc(ponh.rate_date),trunc(ponh.creation_date)) rate_date
192: FROM
193: pon_auction_headers_all ponh,
194: financials_system_params_all pfsp,
195: gl_sets_of_books pgl,
196: pon_auc_doctypes doctype
197: WHERE
198: nvl(ponh.auction_status,'DRAFT') <> 'DRAFT'
199: and ponh.auction_type = 'REVERSE' /* Forward Auctions not considered */

Line 222: gl_sets_of_books pgl,

218: FROM
219: pon_auction_headers_all ponh,
220: pon_bid_headers ponbh,
221: financials_system_params_all pfsp,
222: gl_sets_of_books pgl,
223: pon_auc_doctypes doctype
224: WHERE
225: nvl(ponh.auction_status,'DRAFT') <> 'DRAFT'
226: and ponh.auction_type = 'REVERSE' /* Forward Auctions not considered */

Line 511: gl_sets_of_books pgl,

507: -- pon_backing_requisitions ponreq,
508: financials_system_params_all pfsp,
509: mtl_parameters ppar,
510: mtl_system_items pitem,
511: gl_sets_of_books pgl,
512: hz_parties hz,
513: mtl_units_of_measure uom,
514: pon_auc_doctypes doctype,
515: pon_auction_headers_all ponh_multi,

Line 636: gl_sets_of_books pgl,

632: -- pon_backing_requisitions ponreq,
633: financials_system_params_all pfsp,
634: mtl_parameters ppar,
635: mtl_system_items pitem,
636: gl_sets_of_books pgl,
637: hz_parties hz,
638: mtl_units_of_measure uom,
639: pon_auc_doctypes doctype,
640: pon_auction_headers_all ponh_multi,