DBA Data[Home] [Help]

APPS.PNRX_SP_ASSIGN_BY_LOC dependencies on PN_MO_CACHE_UTILS

Line 186: WHERE set_of_books_id= TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',

182: errbuf:='';
183: fnd_profile.get('LOGIN_ID', l_login_id);
184: SELECT chart_of_accounts_id into v_coa_id
185: FROM gl_sets_of_books
186: WHERE set_of_books_id= TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
187: pn_mo_cache_utils.get_current_org_id));
188:
189: l_cursor := dbms_sql.open_cursor;
190:

Line 187: pn_mo_cache_utils.get_current_org_id));

183: fnd_profile.get('LOGIN_ID', l_login_id);
184: SELECT chart_of_accounts_id into v_coa_id
185: FROM gl_sets_of_books
186: WHERE set_of_books_id= TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
187: pn_mo_cache_utils.get_current_org_id));
188:
189: l_cursor := dbms_sql.open_cursor;
190:
191: --property code conditions