DBA Data[Home] [Help]

APPS.FV_FACTS1_GL_PKG dependencies on GL_IMPORT_REFERENCES

Line 1830: FROM gl_import_references gli,

1826: CURSOR be_cursor IS
1827: SELECT xd.source_distribution_id_num_1 transaction_id,
1828: (NVL(xd.unrounded_accounted_dr,0) -
1829: NVL(xd.unrounded_accounted_cr,0)) amount
1830: FROM gl_import_references gli,
1831: xla_ae_lines xl,
1832: xla_ae_headers xh,
1833: xla_distribution_links xd
1834: WHERE gli.je_batch_id = p_je_batch_id

Line 1850: FROM gl_import_references i,

1846: CURSOR other_source_cur IS
1847: SELECT ael.party_id,
1848: NVL(ael.accounted_dr,0) -
1849: NVL(ael.accounted_cr,0) amount
1850: FROM gl_import_references i,
1851: xla_ae_lines ael
1852: WHERE i.je_batch_id = p_je_batch_id
1853: AND i.je_header_id = p_je_header_id
1854: AND i.je_line_num = p_je_line_num