APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on GL_SETS_OF_BOOKS

Line 1111: l_functional_currency_code gl_sets_of_books.currency_code%TYPE;

1107: l_line_cancel_flag varchar2(1);
1108: l_shipment_cancel_flag varchar2(1);
1109:
1110: l_po_currency_code PO_HEADERS_ALL.currency_code%type;
1111: l_functional_currency_code gl_sets_of_books.currency_code%TYPE;
1112: l_org_id number;
1113:
1114: cursor l_pending_change_csr(p_change_request_group_id in number) is
1115: select pcr.document_type,

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 4673: gl_sets_of_books gsb

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:
4677: -- get old req amount and amount dsp

Line 8213: gl_sets_of_books gsb

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:
8217: t_varname(3) := 'FUNCTIONAL_CURRENCY' ;

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 11170: l_functional_currency_code gl_sets_of_books.currency_code%TYPE;

11166: l_api_name varchar2(30) := 'Changes_Wthn_Buyer_Tol_Values';
11167: l_progress VARCHAR2(100) := '000';
11168:
11169: l_po_currency_code PO_HEADERS_ALL.currency_code%type;
11170: l_functional_currency_code gl_sets_of_books.currency_code%TYPE;
11171: l_org_id number;
11172: l_po_doc_type VARCHAR2(25);
11173:
11174: BEGIN

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';