APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 1221: FROM gl_sets_of_books sob, financials_system_params_all fsp

1217: -- in different currency ).
1218:
1219: SELECT sob.currency_code
1220: INTO l_functional_currency_code
1221: FROM gl_sets_of_books sob, financials_system_params_all fsp
1222: WHERE fsp.org_id = l_org_id
1223: AND fsp.set_of_books_id = sob.set_of_books_id;
1224:
1225: if(l_po_quantity<>l_new_quantity OR

Line 4512: FROM financials_system_params_all fsp,

4508: if (p_process='PROCESS_BUYER_RESPONSE') then
4509:
4510: SELECT gsb.currency_code
4511: INTO l_currency_code
4512: FROM financials_system_params_all fsp,
4513: gl_sets_of_books gsb
4514: WHERE fsp.set_of_books_id = gsb.set_of_books_id
4515: AND fsp.org_id = l_org_id;
4516:

Line 7926: FROM financials_system_params_all fsp,

7922: x_progress := 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency: 06';
7923:
7924: SELECT gsb.currency_code
7925: INTO l_functional_currency
7926: FROM financials_system_params_all fsp,
7927: gl_sets_of_books gsb
7928: WHERE fsp.set_of_books_id = gsb.set_of_books_id
7929: AND fsp.org_id = l_orgid;
7930:

Line 9372: FROM gl_sets_of_books sob, financials_system_params_all fsp

9368: BEGIN
9369:
9370: SELECT sob.currency_code
9371: INTO l_functional_currency_code
9372: FROM gl_sets_of_books sob, financials_system_params_all fsp
9373: WHERE fsp.org_id = p_org_id
9374: AND fsp.set_of_books_id = sob.set_of_books_id;
9375:
9376: select poh.rate

Line 10832: FROM gl_sets_of_books sob, financials_system_params_all fsp

10828: l_progress := '002';
10829:
10830: SELECT sob.currency_code
10831: INTO l_functional_currency_code
10832: FROM gl_sets_of_books sob, financials_system_params_all fsp
10833: WHERE fsp.org_id = l_org_id
10834: AND fsp.set_of_books_id = sob.set_of_books_id;
10835:
10836: l_progress := '003';

Line 12523: financials_system_params_all fsp,

12519: into l_planner_id
12520: FROM po_change_requests pcr,
12521: po_requisition_lines_all prl,
12522: mtl_system_items_b mi,
12523: financials_system_params_all fsp,
12524: mtl_planners mp
12525: WHERE pcr.change_request_group_id =l_change_request_group_id
12526: AND pcr.change_request_id =L_CHANGE_REQUEST_ID
12527: AND pcr.request_status = 'ACCEPTED'

Line 12549: financials_system_params_all fsp,

12545: SELECT mp.EMPLOYEE_ID
12546: FROM po_change_requests pcr,
12547: po_requisition_lines_all prl,
12548: mtl_system_items_b mi,
12549: financials_system_params_all fsp,
12550: mtl_planners mp
12551: WHERE pcr.change_request_group_id =:1
12552: AND pcr.change_request_id =:2
12553: AND pcr.request_status = ''ACCEPTED''