DBA Data[Home] [Help]

APPS.PO_PALT_ASSIGNMENTS dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 418: FROM GL_SETS_OF_BOOKS s, FINANCIALS_SYSTEM_PARAMS_ALL f

414: x_currCode VARCHAR2(12);
415: BEGIN
416:
417: SELECT s.CURRENCY_CODE INTO x_currCode
418: FROM GL_SETS_OF_BOOKS s, FINANCIALS_SYSTEM_PARAMS_ALL f
419: WHERE s.SET_OF_BOOKS_ID = f.SET_OF_BOOKS_ID
420: AND f.ORG_ID = p_org_id;
421:
422: RETURN x_currCode;

Line 440: FROM GL_SETS_OF_BOOKS s, FINANCIALS_SYSTEM_PARAMS_ALL f

436:
437: SELECT ORG_ID INTO x_org_id FROM po_requisition_lines_all WHERE REQUISITION_LINE_ID = p_line_id;
438:
439: SELECT s.CURRENCY_CODE INTO x_currCode
440: FROM GL_SETS_OF_BOOKS s, FINANCIALS_SYSTEM_PARAMS_ALL f
441: WHERE s.SET_OF_BOOKS_ID = f.SET_OF_BOOKS_ID
442: AND f.ORG_ID = x_org_id;
443:
444: RETURN x_currCode;