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 584: FROM FINANCIALS_SYSTEM_PARAMS_ALL

580: if applicable */
581: BEGIN
582: SELECT nvl(req_encumbrance_flag,'N') /*nvl(purch_encumbrance_flag, 'N')Bug 6469694*/
583: INTO l_purch_encum_flag
584: FROM FINANCIALS_SYSTEM_PARAMS_ALL
585: WHERE set_of_books_id = l_sob_id
586: AND org_id = l_operating_unit;
587: EXCEPTION
588: WHEN no_data_found THEN

Line 6650: FROM FINANCIALS_SYSTEM_PARAMS_ALL

6646:
6647: l_stmt_num := 6;
6648: SELECT REQ_ENCUMBRANCE_TYPE_ID,PURCH_ENCUMBRANCE_TYPE_ID
6649: INTO l_req_enc_id, l_po_enc_id
6650: FROM FINANCIALS_SYSTEM_PARAMS_ALL
6651: WHERE SET_OF_BOOKS_ID = i_sob_id AND
6652: NVL(org_id,-999) = DECODE(l_operating_unit,-1,-999,l_operating_unit);
6653:
6654: end if;