[Home] [Help]
2738: AND l.ledger_id = fsp.set_of_books_id
2739: );
2740:
2741: CURSOR c_opm_count IS
2742: SELECT 1 FROM gmf_rcv_accounting_txns
2743: WHERE org_id = p_operating_unit
2744: AND rownum < 2;
2745: l_opm_count NUMBER;
2746:
3448: SELECT /*+ LEADING(rt) USE_NL(grat,pod) */
3449: DISTINCT pod.po_distribution_id
3450: FROM po_distributions_all pod,
3451: rcv_transactions rt,
3452: gmf_rcv_accounting_txns grat
3453: WHERE pod.accrual_account_id is NOT NULL
3454: AND pod.accrue_on_receipt_flag = 'Y'
3455: /*Bug 12346836 - Replaced rt.transaction_date with grat.transaction_date here*/
3456: AND grat.transaction_date between p_from_date AND p_to_date
3536:
3537: po_dists_tab dists_table;
3538:
3539: CURSOR c_opm_count IS
3540: SELECT 1 FROM gmf_rcv_accounting_txns
3541: WHERE org_id = p_operating_unit
3542: AND rownum <2 ;
3543: l_opm_count NUMBER;
3544:
3773: l_request_id,
3774: xal.ae_header_id,
3775: xal.ae_line_num
3776: FROM rcv_transactions rct,
3777: gmf_rcv_accounting_txns grat,
3778: gmf_xla_extract_headers geh,
3779: gmf_xla_extract_lines gel,
3780: xla_ae_headers xah,
3781: xla_ae_lines xal,