DBA Data[Home] [Help]

APPS.CN_INVOICE_CHANGES_PVT dependencies on CN_COMMISSION_HEADERS_ALL

Line 1730: FROM cn_commission_headers_all ch

1726: SELECT comm_lines_api_id,
1727: invoice_number,
1728: line_number,
1729: revenue_type
1730: FROM cn_commission_headers_all ch
1731: WHERE ch.invoice_number = p_invoice_number
1732: AND ch.trx_type = p_trx_type
1733: AND ch.org_id = p_org_id
1734: AND (ch.adjust_status NOT IN ('FROZEN','REVERSAL')); -- OR