DBA Data[Home] [Help]

APPS.CSTPAVCP dependencies on FINANCIALS_SYSTEM_PARAMS_ALL

Line 8114: l_encumbrance_flag FINANCIALS_SYSTEM_PARAMS_ALL.PURCH_ENCUMBRANCE_FLAG%TYPE;

8110: l_debit_account NUMBER;
8111: l_credit_account NUMBER;
8112: l_set_of_books_id NUMBER;
8113: l_ou_id NUMBER;
8114: l_encumbrance_flag FINANCIALS_SYSTEM_PARAMS_ALL.PURCH_ENCUMBRANCE_FLAG%TYPE;
8115:
8116: l_enc_amount NUMBER;
8117: l_enc_account NUMBER;
8118: l_credit_line_type NUMBER;

Line 8759: FROM FINANCIALS_SYSTEM_PARAMS_ALL

8755: /* Compute Encumbrance Amount and create the reversal entry,
8756: if applicable */
8757: SELECT nvl(req_encumbrance_flag,'N') /*nvl(purch_encumbrance_flag, 'N')Bug 6469694*/
8758: INTO l_encumbrance_flag
8759: FROM FINANCIALS_SYSTEM_PARAMS_ALL
8760: WHERE set_of_books_id = l_set_of_books_id
8761: AND ( ( l_ou_id is not NULL AND org_id = l_ou_id ) OR
8762: ( l_ou_id is null ) );
8763: