APPS.AP_ACCOUNTING_PAY_PKG dependencies on XLA_AE_HEADERS

Line 1997: xla_ae_headers xah

1993: -- check for non-reversed, upgrade prepay application accounting w.r.t prepay_distribution_id
1994: select count(1)
1995: into l_upg_appl_actg_for_prep_dist
1996: from ap_invoice_distributions_all aid,
1997: xla_ae_headers xah
1998: where aid.prepay_distribution_id = p_prepay_distribution_id
1999: and nvl(aid.reversal_flag, 'N') <> 'Y'
2000: and aid.accounting_event_id = xah.event_id
2001: and aid.set_of_books_id = xah.ledger_id

Line 2034: xla_ae_headers xah

2030: select count(1)
2031: into l_upg_pay_actg_for_inv
2032: from ap_payment_history_all aph,
2033: ap_system_parameters_all asp,
2034: xla_ae_headers xah
2035: where aph.check_id in
2036: (select aip.check_id
2037: from ap_invoice_payments_all aip
2038: where aip.invoice_id = p_inv_rec.invoice_id

Line 2066: xla_ae_headers xah

2062: select count(1)
2063: into l_upg_pay_actg_for_inv
2064: from ap_payment_history_all aph,
2065: ap_system_parameters_all asp,
2066: xla_ae_headers xah
2067: where aph.check_id in
2068: (select aip.check_id
2069: from ap_invoice_payments_all aip
2070: where aip.invoice_id = p_inv_rec.invoice_id

Line 2098: xla_ae_headers xah

2094: select count(1)
2095: into l_upg_pay_actg_for_inv
2096: from ap_payment_history_all aph,
2097: ap_system_parameters_all asp,
2098: xla_ae_headers xah
2099: where aph.check_id in
2100: (select aip.check_id
2101: from ap_invoice_payments_all aip
2102: where aip.invoice_id = p_inv_rec.invoice_id

Line 2135: xla_ae_headers xah

2131: -- check for non-reversed, upgrade prepay application accounting w.r.t invoice_id
2132: select count(1)
2133: into l_upg_appl_actg_for_inv
2134: from ap_invoice_distributions_all aid,
2135: xla_ae_headers xah
2136: where aid.invoice_id = p_inv_rec.invoice_id
2137: and nvl(aid.reversal_flag, 'N') <> 'Y'
2138: and aid.accounting_event_id = xah.event_id
2139: and aid.set_of_books_id = xah.ledger_id

Line 2164: xla_ae_headers xah

2160: select count(1)
2161: into l_upg_pay_all_actg_for_inv
2162: from ap_payment_history_all aph,
2163: ap_system_parameters_all asp,
2164: xla_ae_headers xah
2165: where aph.check_id in
2166: (select aip.check_id
2167: from ap_invoice_payments_all aip
2168: where aip.invoice_id = p_invoice_payment_id