APPS.IGIPMGLT dependencies on IGI_MPP_SUBLEDGER

Line 141: FROM igi_mpp_subledger slgr

137: IS
138:
139: CURSOR c_subledger IS
140: SELECT slgr.*
141: FROM igi_mpp_subledger slgr
142: WHERE slgr.period_name = p_period_name
143: AND slgr.set_of_books_id = p_sob_id
144: AND slgr.expense_recognized_flag = 'Y'
145: AND slgr.gl_posted_flag = 'N'

Line 252: UPDATE igi_mpp_subledger

248: '>> >> >> Built the interface info... ' );
249: END IF;
250: --bug 3199481 fnd logging changes: sdixit: end block
251:
252: UPDATE igi_mpp_subledger
253: SET gl_posted_flag = 'Y'
254: , date_created_in_gl = g_date
255: WHERE subledger_entry_id = l_slgr.subledger_entry_id
256: AND nvl(gl_posted_flag,'N') = 'N'

Line 271: FROM igi_mpp_subledger

267: AND NVL(gl_posted_flag,'N') = 'N'
268: AND expense_recognized_flag = 'Y'
269: and EXISTS
270: ( SELECT 'x'
271: FROM igi_mpp_subledger
272: WHERE gl_posted_flag = 'Y'
273: AND expense_recognized_flag = 'Y'
274: AND invoice_id = l_slgr.invoice_id
275: AND distribution_line_number =

Line 339: FROM igi_mpp_subledger

335:
336: CURSOR c_currency ( cp_period_name in varchar2
337: , cp_sob_id in number ) IS
338: SELECT DISTINCT currency_code
339: FROM igi_mpp_subledger
340: WHERE period_name = cp_period_name
341: and set_of_books_id = cp_sob_id
342: ;
343:

Line 353: FROM igi_mpp_subledger

349: , SUM( nvl( accounted_dr, 0) ) sum_accounted_dr
350: , SUM( nvl( accounted_cr, 0) ) sum_accounted_cr
351: , SUM( nvl( entered_dr, 0) ) sum_entered_dr
352: , SUM( nvl( entered_cr, 0) ) sum_entered_cr
353: FROM igi_mpp_subledger
354: WHERE period_name = cp_period_name
355: AND expense_recognized_flag = 'Y'
356: AND gl_posted_flag = 'N'
357: AND seT_of_books_id = cp_sob_id