DBA Data[Home] [Help]

APPS.GL_MANAGEMENT_SEGMENT_UPGRADE dependencies on GL_JE_LINES

Line 337: GL_JE_LINES L,

333: 'SEGMENT30', cc.segment30),
334: sysdate, l_user_id, sysdate, l_user_id, l_login_id
335: FROM GL_MGT_SEG_UPGRADE_GT GT,
336: GL_JE_HEADERS H,
337: GL_JE_LINES L,
338: GL_CODE_COMBINATIONS CC
339: WHERE h.je_batch_id = gt.je_batch_id
340: AND l.je_header_id = h.je_header_id
341: AND cc.code_combination_id = l.code_combination_id

Line 439: GL_JE_LINES L,

435: 'SEGMENT30', cc.segment30),
436: sysdate, l_user_id, sysdate, l_user_id, l_login_id
437: FROM GL_JE_BATCHES B,
438: GL_JE_HEADERS H,
439: GL_JE_LINES L,
440: GL_CODE_COMBINATIONS CC
441: WHERE b.je_batch_id BETWEEN low_batch_id AND high_batch_id
442: AND b.status || '' = 'P'
443: AND b.chart_of_accounts_id = X_Chart_Of_Accounts_Id

Line 608: GL_JE_LINES L,

604: 'SEGMENT30', cc.segment30),
605: sysdate, l_user_id, sysdate, l_user_id, l_login_id
606: FROM GL_MGT_SEG_UPGRADE MSU,
607: GL_JE_HEADERS H,
608: GL_JE_LINES L,
609: GL_CODE_COMBINATIONS CC
610: WHERE msu.chart_of_accounts_id = X_Chart_Of_Accounts_Id
611: AND h.je_batch_id = msu.je_batch_id
612: AND l.je_header_id = h.je_header_id

Line 687: GL_JE_LINES L,

683: 'SEGMENT30', cc.segment30),
684: sysdate, l_user_id, sysdate, l_user_id, l_login_id
685: FROM GL_JE_BATCHES B,
686: GL_JE_HEADERS H,
687: GL_JE_LINES L,
688: GL_CODE_COMBINATIONS CC
689: WHERE b.je_batch_id > l_max_proc_batch_id
690: AND b.chart_of_accounts_id = X_Chart_Of_Accounts_Id
691: AND h.je_batch_id = b.je_batch_id