DBA Data[Home] [Help]

APPS.PO_RCO_VALIDATION_PVT dependencies on GL_SETS_OF_BOOKS

Line 1195: l_functional_currency gl_sets_of_books.currency_code%TYPE;

1191: */
1192: FUNCTION calculate_newunitprice(p_req_line_id NUMBER, p_new_price NUMBER) RETURN NUMBER
1193: IS
1194: l_transaction_currency po_requisition_lines_all.currency_code%TYPE;
1195: l_functional_currency gl_sets_of_books.currency_code%TYPE;
1196: l_rate_type po_requisition_lines_all.rate_type%TYPE;
1197: l_conversion_date DATE;
1198: l_rate NUMBER;
1199: l_unit_price NUMBER;

Line 1215: gl_sets_of_books gsob,

1211:
1212: SELECT currency_code, fsp.set_of_books_id
1213: INTO l_functional_currency, l_set_of_books_id
1214: FROM
1215: gl_sets_of_books gsob,
1216: financials_system_parameters fsp
1217: WHERE fsp.set_of_books_id = gsob.set_of_books_id;
1218:
1219: IF(l_transaction_currency <> l_functional_currency) THEN

Line 4507: GL_SETS_OF_BOOKS GL_SOB

4503: INTO l_gl_period
4504: FROM
4505: GL_PERIOD_STATUSES GL_PS,
4506: GL_PERIOD_STATUSES PO_PS,
4507: GL_SETS_OF_BOOKS GL_SOB
4508: WHERE
4509: -- Join conditions:
4510: GL_SOB.set_of_books_id = (l_set_of_books_id)
4511: AND GL_PS.set_of_books_id = GL_SOB.set_of_books_id