DBA Data[Home] [Help]

APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 1238: FROM gl_sets_of_books sob, financials_system_params_all fsp

1234: -- in different currency ).
1235:
1236: SELECT sob.currency_code
1237: INTO l_functional_currency_code
1238: FROM gl_sets_of_books sob, financials_system_params_all fsp
1239: WHERE fsp.org_id = l_org_id
1240: AND fsp.set_of_books_id = sob.set_of_books_id;
1241:
1242: if(l_po_quantity<>l_new_quantity OR

Line 4672: FROM financials_system_params_all fsp,

4668: if (p_process='PROCESS_BUYER_RESPONSE') then
4669:
4670: SELECT gsb.currency_code
4671: INTO l_currency_code
4672: FROM financials_system_params_all fsp,
4673: gl_sets_of_books gsb
4674: WHERE fsp.set_of_books_id = gsb.set_of_books_id
4675: AND fsp.org_id = l_org_id;
4676:

Line 8212: FROM financials_system_params_all fsp,

8208: x_progress := 'PO_ReqChangeRequestWF_PVT.Get_Total_Amount_Currency: 06';
8209:
8210: SELECT gsb.currency_code
8211: INTO l_functional_currency
8212: FROM financials_system_params_all fsp,
8213: gl_sets_of_books gsb
8214: WHERE fsp.set_of_books_id = gsb.set_of_books_id
8215: AND fsp.org_id = l_orgid;
8216:

Line 9759: FROM gl_sets_of_books sob, financials_system_params_all fsp

9755: BEGIN
9756:
9757: SELECT sob.currency_code
9758: INTO l_functional_currency_code
9759: FROM gl_sets_of_books sob, financials_system_params_all fsp
9760: WHERE fsp.org_id = p_org_id
9761: AND fsp.set_of_books_id = sob.set_of_books_id;
9762:
9763: select poh.rate

Line 11222: FROM gl_sets_of_books sob, financials_system_params_all fsp

11218: l_progress := '002';
11219:
11220: SELECT sob.currency_code
11221: INTO l_functional_currency_code
11222: FROM gl_sets_of_books sob, financials_system_params_all fsp
11223: WHERE fsp.org_id = l_org_id
11224: AND fsp.set_of_books_id = sob.set_of_books_id;
11225:
11226: l_progress := '003';

Line 13115: financials_system_params_all fsp,

13111: into l_planner_id
13112: FROM po_change_requests pcr,
13113: po_requisition_lines_all prl,
13114: mtl_system_items_b mi,
13115: financials_system_params_all fsp,
13116: mtl_planners mp
13117: WHERE pcr.change_request_group_id =l_change_request_group_id
13118: AND pcr.change_request_id =L_CHANGE_REQUEST_ID
13119: AND pcr.request_status = 'ACCEPTED'

Line 13141: financials_system_params_all fsp,

13137: SELECT mp.EMPLOYEE_ID
13138: FROM po_change_requests pcr,
13139: po_requisition_lines_all prl,
13140: mtl_system_items_b mi,
13141: financials_system_params_all fsp,
13142: mtl_planners mp
13143: WHERE pcr.change_request_group_id =:1
13144: AND pcr.change_request_id =:2
13145: AND pcr.request_status = ''ACCEPTED''