APPS.PSA_MFAR_VAL_PKG dependencies on GL_SETS_OF_BOOKS

Line 109: from GL_SETS_OF_BOOKS sob,AR_SYSTEM_PARAMETERS_ALL sp

105: +-------------------------------------------------------------------------*/
106:
107: select sob.currency_code
108: into l_base_currency
109: from GL_SETS_OF_BOOKS sob,AR_SYSTEM_PARAMETERS_ALL sp
110: where sob.set_of_books_id = X_SET_OF_BOOKS_ID
111: and sob.set_of_books_id = sp.set_of_books_id
112: and rownum < 2 ;
113:

Line 239: from GL_SETS_OF_BOOKS sob,AR_SYSTEM_PARAMETERS_ALL sp

235: -- return;
236:
237: select sob.currency_code
238: into l_base_currency
239: from GL_SETS_OF_BOOKS sob,AR_SYSTEM_PARAMETERS_ALL sp
240: where sob.set_of_books_id = X_SET_OF_BOOKS_ID
241: and sob.set_of_books_id = sp.set_of_books_id
242: and rownum < 2 ;
243:

Line 555: l_set_of_books_id gl_sets_of_books.set_of_books_id%type;

551: l_currency_check varchar2(1) ;
552: l_base_currency varchar2(15);
553: l_payment_method_check varchar2(1) ;
554: -- it_id item ;
555: l_set_of_books_id gl_sets_of_books.set_of_books_id%type;
556: -- ========================= FND LOG ===========================
557: l_full_path VARCHAR2(100) := g_path || 'AR_LOCKBOX_VALIDATION';
558: -- ========================= FND LOG ===========================
559:

Line 571: from GL_SETS_OF_BOOKS sob,AR_SYSTEM_PARAMETERS_ALL sp

567: -- it_id := FIND_ITEM('LBSUB.PB_SUBMIT') ;
568: begin
569: select sob.currency_code
570: into l_base_currency
571: from GL_SETS_OF_BOOKS sob,AR_SYSTEM_PARAMETERS_ALL sp
572: where sob.set_of_books_id = l_set_of_books_id
573: and sob.set_of_books_id = sp.set_of_books_id
574: and rownum < 2 ;
575:

Line 714: from GL_SETS_OF_BOOKS sob,AR_SYSTEM_PARAMETERS_ALL sp

710: WHERE B.CUST_TRX_TYPE_ID = C.PSA_TRX_TYPE_ID
711: AND B.CUST_TRX_TYPE_ID = L.CUST_TRX_TYPE_ID )
712: AND not exists
713: (select 'X'
714: from GL_SETS_OF_BOOKS sob,AR_SYSTEM_PARAMETERS_ALL sp
715: where sob.set_of_books_id = L.SET_OF_BOOKS_ID
716: and sob.set_of_books_id = sp.set_of_books_id
717: and sob.currency_code = L.currency_code
718: and rownum < 2 );