[Home] [Help]
1074: CURSOR be_cursor IS
1075: SELECT xd.source_distribution_id_num_1 transaction_id,
1076: xte.transaction_number
1077: --, (NVL(xd.unrounded_accounted_dr,0) - NVL(xd.unrounded_accounted_cr,0)) amount
1078: FROM gl_import_references gli,
1079: xla_ae_lines xl ,
1080: xla_ae_headers xh ,
1081: xla_distribution_links xd,
1082: xla_transaction_entities xte
1572: IS
1573: SELECT ael.party_id,
1574: NVL(ael.accounted_dr,0) - NVL(ael.accounted_cr,0) amount,
1575: xte.transaction_number
1576: FROM gl_import_references i,
1577: xla_ae_lines ael,
1578: xla_ae_headers aeh,
1579: xla_transaction_entities xte
1580: WHERE i.je_batch_id = p_je_batch_id
1592: SELECT pc.customer_id party_id,
1593: NVL(ael.accounted_dr,0) - NVL(ael.accounted_cr,0) amount,
1594: xte.transaction_number
1595: FROM gl_je_lines je ,
1596: gl_import_references gir ,
1597: xla_ae_lines ael ,
1598: xla_ae_headers aeh ,
1599: pa_draft_revenues_all pdr,
1600: pa_agreements_all agr ,
1619: SELECT (NVL(xd.unrounded_accounted_dr,0) - NVL(xd.unrounded_accounted_cr,0)) amount,
1620: bd.transaction_id,
1621: bd.dept_id, bd.main_account,
1622: bh.doc_number
1623: FROM gl_import_references gli,
1624: xla_ae_lines xl ,
1625: xla_ae_headers xh ,
1626: xla_distribution_links xd,
1627: xla_transaction_entities xte,
1644: CURSOR cst_cursor IS
1645: SELECT
1646: (NVL(xd.unrounded_accounted_dr,0)-NVL(xd.unrounded_accounted_cr,0)) amount,
1647: reference4 doc_num, poh.vendor_id, rc.rcv_transaction_id
1648: FROM gl_import_references gli,
1649: xla_ae_lines xl ,
1650: xla_ae_headers xh ,
1651: xla_distribution_links xd,
1652: rcv_receiving_sub_ledger rc,
1667: CURSOR trs_confirm_cursor IS
1668: SELECT
1669: (NVL(xd.unrounded_accounted_dr,0)-NVL(xd.unrounded_accounted_cr,0)) amount,
1670: aip.check_id
1671: FROM gl_import_references gli,
1672: xla_ae_lines xl ,
1673: xla_ae_headers xh ,
1674: xla_distribution_links xd,
1675: ap_invoice_payments_all aip,
2276: l_sla_event_id NUMBER;
2277: CURSOR event_lines_cur IS
2278: SELECT event_id
2279: INTO l_sla_event_id
2280: FROM gl_import_references gli,
2281: xla_ae_lines l,
2282: xla_ae_headers h
2283: WHERE gli.je_batch_id = p_je_batch_id
2284: AND gli.je_header_id = p_je_header_id
2303: --then this logic applies
2304: /*
2305: SELECT event_id
2306: INTO l_sla_event_id
2307: FROM gl_import_references gli,
2308: xla_ae_lines l,
2309: xla_ae_headers h
2310: WHERE gli.je_batch_id = p_je_batch_id
2311: AND gli.je_header_id = p_je_header_id