DBA Data[Home] [Help]

APPS.GL_JE_SEGMENT_VALUES_PKG dependencies on GL_LEDGERS

Line 79: gl_ledgers LDG,

75: 'SEGMENT29',cc.SEGMENT29,
76: 'SEGMENT30',cc.SEGMENT30),
77: sysdate, user_id, sysdate, user_id, login_id
78: FROM gl_code_combinations CC,
79: gl_ledgers LDG,
80: gl_je_lines LINE,
81: gl_row_multipliers X
82: WHERE CC.code_combination_id = LINE.code_combination_id
83: AND LDG.ledger_id = LINE.ledger_id

Line 190: gl_ledgers LDG,

186: 'SEGMENT29',cc.SEGMENT29,
187: 'SEGMENT30',cc.SEGMENT30),
188: sysdate, x_user_id, sysdate, x_user_id, x_login_id
189: FROM gl_code_combinations CC,
190: gl_ledgers LDG,
191: gl_je_lines LINE,
192: gl_row_multipliers X
193: WHERE CC.code_combination_id = LINE.code_combination_id
194: AND LDG.ledger_id = LINE.ledger_id

Line 314: gl_ledgers LDG,

310: 'SEGMENT29',cc.SEGMENT29,
311: 'SEGMENT30',cc.SEGMENT30),
312: sysdate, user_id, sysdate, user_id, login_id
313: FROM gl_code_combinations CC,
314: gl_ledgers LDG,
315: gl_je_lines LINE,
316: gl_je_headers JH,
317: gl_row_multipliers X
318: WHERE CC.code_combination_id = LINE.code_combination_id

Line 395: FROM gl_access_sets acs, gl_ledgers lgr

391: SELECT bal_seg_column_name,
392: mgt_seg_column_name
393: INTO bsv_colname,
394: msv_colname
395: FROM gl_access_sets acs, gl_ledgers lgr
396: WHERE acs.access_set_id = asid
397: AND lgr.chart_of_accounts_id = acs.chart_of_accounts_id
398: AND rownum <= 1;
399:

Line 528: FROM gl_je_headers jeh, gl_ledgers lgr

524: SELECT bal_seg_column_name,
525: mgt_seg_column_name
526: INTO bsv_colname,
527: msv_colname
528: FROM gl_je_headers jeh, gl_ledgers lgr
529: WHERE jeh.je_header_id = header_id
530: AND lgr.ledger_id = jeh.ledger_id;
531:
532: -- Bug fix 6761820.

Line 641: gl_ledgers LDG,

637: FROM gl_je_batches JB,
638: gl_je_headers JH,
639: gl_je_lines LINE,
640: gl_code_combinations CC,
641: gl_ledgers LDG,
642: gl_row_multipliers X
643: WHERE JB.posting_run_id = x_prun_id
644: AND JB.status = 'I'
645: AND JH.je_batch_id = JB.je_batch_id

Line 757: gl_ledgers LDG,

753: sysdate, x_last_updated_by, sysdate,
754: x_last_updated_by, x_last_update_login
755: FROM gl_je_headers JH,
756: gl_je_lines LINE,
757: gl_ledgers LDG,
758: gl_code_combinations CC,
759: gl_row_multipliers X
760: WHERE JH.je_header_id = x_je_header_id
761: AND JH.display_alc_journal_flag IS NULL

Line 915: gl_ledgers LDG,

911: gl_je_headers JEH,
912: gl_je_headers SLJEH,
913: gl_je_lines SLJEL,
914: gl_code_combinations CC,
915: gl_ledgers LDG,
916: gl_row_multipliers X
917: WHERE JEB.posting_run_id = x_prun_id
918: AND JEB.status = 'I'
919: AND JEH.je_batch_id = JEB.je_batch_id