APPS.POA_DBI_SAVINGS_PKG dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 45: ,financials_system_params_all fsp

41: ,b.min_release_amount b_min,b.amount_limit , b.global_agreement_flag
42: ,0 line_qty,0 line_all_qty, gl.currency_code bl_func_cur_code, b.rate bl_rate
43: from po_lines_all bl
44: ,po_headers_all b
45: ,financials_system_params_all fsp
46: ,gl_sets_of_books gl
47: where bl.item_id = p_item_id
48: and bl.price_break_lookup_code is not null
49: and bl.unit_meas_lookup_code = p_unit_meas_lookup_code

Line 61: financials_system_params_all fsp1,

57: and pgoa.enabled_flag = 'Y'
58: and ((pgoa.purchasing_org_id in
59: (select tfh.start_org_id
60: from mtl_procuring_txn_flow_hdrs_v tfh,
61: financials_system_params_all fsp1,
62: financials_system_params_all fsp2
63: where p_creation_date between nvl(tfh.start_date, p_creation_date) and nvl(tfh.end_date, p_creation_date)
64: and fsp1.org_id = tfh.start_org_id
65: and fsp1.purch_encumbrance_flag = 'N'

Line 62: financials_system_params_all fsp2

58: and ((pgoa.purchasing_org_id in
59: (select tfh.start_org_id
60: from mtl_procuring_txn_flow_hdrs_v tfh,
61: financials_system_params_all fsp1,
62: financials_system_params_all fsp2
63: where p_creation_date between nvl(tfh.start_date, p_creation_date) and nvl(tfh.end_date, p_creation_date)
64: and fsp1.org_id = tfh.start_org_id
65: and fsp1.purch_encumbrance_flag = 'N'
66: and fsp2.org_id = tfh.end_org_id