APPS.PO_REQCHANGEREQUESTWF_PVT dependencies on GL_SETS_OF_BOOKS

Line 1094: l_functional_currency_code gl_sets_of_books.currency_code%TYPE;

1090: l_line_cancel_flag varchar2(1);
1091: l_shipment_cancel_flag varchar2(1);
1092:
1093: l_po_currency_code PO_HEADERS_ALL.currency_code%type;
1094: l_functional_currency_code gl_sets_of_books.currency_code%TYPE;
1095: l_org_id number;
1096:
1097: cursor l_pending_change_csr(p_change_request_group_id in number) is
1098: select pcr.document_type,

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

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

Line 7927: gl_sets_of_books gsb

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

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

10776: l_api_name varchar2(30) := 'Changes_Wthn_Buyer_Tol_Values';
10777: l_progress VARCHAR2(100) := '000';
10778:
10779: l_po_currency_code PO_HEADERS_ALL.currency_code%type;
10780: l_functional_currency_code gl_sets_of_books.currency_code%TYPE;
10781: l_org_id number;
10782: l_po_doc_type VARCHAR2(25);
10783:
10784: BEGIN

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