APPS.POA_DBI_RCV_TXN_F_C dependencies on GL_SETS_OF_BOOKS

Line 78: l_global_cur_code gl_sets_of_books.currency_code%type;

74: d_glob_date DATE;
75: l_rate_type VARCHAR2(30);
76: l_srate_type varchar2(30);
77: l_sec_cur_yn number;
78: l_global_cur_code gl_sets_of_books.currency_code%type;
79: l_sglobal_cur_code gl_sets_of_books.currency_code%type;
80: BEGIN
81: Errbuf :=NULL;
82: Retcode:=0;

Line 79: l_sglobal_cur_code gl_sets_of_books.currency_code%type;

75: l_rate_type VARCHAR2(30);
76: l_srate_type varchar2(30);
77: l_sec_cur_yn number;
78: l_global_cur_code gl_sets_of_books.currency_code%type;
79: l_sglobal_cur_code gl_sets_of_books.currency_code%type;
80: BEGIN
81: Errbuf :=NULL;
82: Retcode:=0;
83: l_global_cur_code := bis_common_parameters.get_currency_code;

Line 175: gl_sets_of_books poa_gl

171: rcv.source_document_code source_document_code
172: from rcv_transactions rcv,
173: po_headers_all poh,
174: financials_system_params_all fsp,
175: gl_sets_of_books poa_gl
176: where ( rcv.last_update_date between d_start_date and d_end_date or
177: poh.last_update_date between d_start_date and d_end_date
178: )
179: and rcv.po_header_id = poh.po_header_id (+)

Line 209: gl_sets_of_books poa_gl

205: rcv.source_document_code source_document_code
206: from rcv_transactions rcv,
207: po_headers_all poh,
208: financials_system_params_all fsp,
209: gl_sets_of_books poa_gl
210: where rcv.last_update_date between d_start_date and d_end_date
211: and rcv.po_header_id = poh.po_header_id (+)
212: and poh.org_id = fsp.org_id (+)
213: and fsp.set_of_books_id = poa_gl.set_of_books_id (+)

Line 228: gl_sets_of_books poa_gl

224: rcv.source_document_code source_document_code
225: from rcv_transactions rcv,
226: po_headers_all poh,
227: financials_system_params_all fsp,
228: gl_sets_of_books poa_gl
229: where
230: poh.last_update_date between d_start_date and d_end_date
231: and rcv.po_header_id = poh.po_header_id (+)
232: and poh.org_id = fsp.org_id (+)

Line 417: gl_sets_of_books poa_gl,

413: poa_dbi_rtx_inc inc,
414: PO_HEADERS_ALL POH,
415: RCV_SHIPMENT_HEADERS RSH,
416: RCV_SHIPMENT_LINES rsl,
417: gl_sets_of_books poa_gl,
418: financials_system_params_all fsp,
419: mtl_system_items item,
420: mtl_parameters param,
421: poa_dbi_rtx_rates rat

Line 503: gl_sets_of_books poa_gl,

499: poa_dbi_rtx_inc inc,
500: PO_HEADERS_ALL POH,
501: RCV_SHIPMENT_HEADERS RSH,
502: RCV_SHIPMENT_LINES rsl,
503: gl_sets_of_books poa_gl,
504: financials_system_params_all fsp,
505: mtl_system_items item,
506: mtl_parameters param,
507: poa_dbi_rtx_rates rat