2013: AND asp.when_to_account_pmt = 'CLEARING ONLY'
2014: AND aphp.accounting_event_id = xe.event_id
2015: AND xe.application_id = 200
2016: AND xe.event_status_code = 'P')
2017: AND NVL(fnd_profile.value('FV_ENABLED'), 'N') <> 'Y' --bug11681786 start
2018: UNION
2019: SELECT accounting_date,
2020: accounting_event_id,
2021: transaction_type
2033: AND aphp.posted_flag = 'Y'
2034: AND aphp.accounting_event_id = xe.event_id
2035: AND xe.application_id = 200
2036: AND xe.event_status_code = 'P')
2037: AND NVL(fnd_profile.value('FV_ENABLED'), 'N') = 'Y'; --bug11681786 end
2038:
2039: --added cursor for bug 7594938, 10336668 added Manual Ref Adj
2040: CURSOR c_pmt_acct_clearing_only IS
2041: SELECT aph.accounting_date,