DBA Data[Home] [Help]

APPS.POS_EXCELASN_PVT dependencies on PO_INTERFACE_ERRORS

Line 65: from po_interface_errors pie1,

61:
62: cursor l_pieExist_csr(x_group_id in number)
63: is
64: select 1
65: from po_interface_errors pie1,
66: rcv_headers_interface rhi
67: where rhi.group_id = x_group_id
68: and rhi.header_interface_id = pie1.interface_header_id
69: union all

Line 71: from po_interface_errors pie2,

67: where rhi.group_id = x_group_id
68: and rhi.header_interface_id = pie1.interface_header_id
69: union all
70: select 1
71: from po_interface_errors pie2,
72: rcv_transactions_interface rti
73: where rti.group_id = x_group_id
74: and rti.interface_transaction_id = pie2.interface_line_id;
75: