DBA Data[Home] [Help]

APPS.CSTPACDP dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 78: l_purch_encum_flag FINANCIALS_SYSTEM_PARAMS_ALL.PURCH_ENCUMBRANCE_FLAG%TYPE;

74: l_conv_type VARCHAR2(30);
75: l_sob_id NUMBER;
76: l_operating_unit NUMBER;
77:
78: l_purch_encum_flag FINANCIALS_SYSTEM_PARAMS_ALL.PURCH_ENCUMBRANCE_FLAG%TYPE;
79: l_enc_rev NUMBER;
80: l_enc_amount NUMBER;
81: l_enc_acct NUMBER;
82:

Line 622: FROM FINANCIALS_SYSTEM_PARAMS_ALL FSP,

618: SELECT nvl(req_encumbrance_flag,'N') /*nvl(purch_encumbrance_flag, 'N')Bug 6469694*/,
619: gsb.currency_code
620: INTO l_purch_encum_flag,
621: l_pri_curr
622: FROM FINANCIALS_SYSTEM_PARAMS_ALL FSP,
623: cst_organization_definitions cod,
624: gl_sets_of_books gsb
625: WHERE fsp.set_of_books_id = cod.set_of_books_id
626: and fsp.org_id= cod.operating_unit