DBA Data[Home] [Help]

APPS.PNRX_SP_ASSIGN_BY_LEASE dependencies on PN_MO_CACHE_UTILS

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

177: errbuf:='';
178: fnd_profile.get('LOGIN_ID', l_login_id);
179: SELECT chart_of_accounts_id INTO v_coa_id
180: FROM GL_SETS_OF_BOOKS
181: WHERE set_of_books_id= TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
182: pn_mo_cache_utils.get_current_org_id));
183: l_lease_number_low := lease_number_low;
184: l_lease_number_high := lease_number_high;
185: --lease number conditions.....

Line 182: pn_mo_cache_utils.get_current_org_id));

178: fnd_profile.get('LOGIN_ID', l_login_id);
179: SELECT chart_of_accounts_id INTO v_coa_id
180: FROM GL_SETS_OF_BOOKS
181: WHERE set_of_books_id= TO_NUMBER(pn_mo_cache_utils.get_profile_value('PN_SET_OF_BOOKS_ID',
182: pn_mo_cache_utils.get_current_org_id));
183: l_lease_number_low := lease_number_low;
184: l_lease_number_high := lease_number_high;
185: --lease number conditions.....
186: IF lease_number_low IS NOT NULL AND lease_number_high IS NOT NULL THEN