APPS.OE_ELECMSGS_PVT dependencies on OE_CREDITS_IFACE_ALL

Line 1820: FROM OE_Credits_Iface_All

1816:
1817: -- Start MOAC
1818: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
1819: DELETE
1820: FROM OE_Credits_Iface_All
1821: WHERE order_source_id = p_order_source_id
1822: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
1823: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1824: AND orig_sys_line_ref IS NULL

Line 1850: FROM OE_Credits_Iface_All

1846:
1847: -- Start MOAC
1848: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
1849: DELETE
1850: FROM OE_Credits_Iface_All
1851: WHERE order_source_id BETWEEN l_min_order_source_id AND l_max_order_source_id
1852: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
1853: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1854: AND orig_sys_line_ref IS NULL

Line 2506: FROM OE_Credits_Iface_All

2502:
2503: -- Start MOAC
2504: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
2505: DELETE
2506: FROM OE_Credits_Iface_All
2507: WHERE order_source_id = p_order_source_id
2508: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2509: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2510: AND orig_sys_line_ref IS NOT NULL

Line 2536: FROM OE_Credits_Iface_All

2532:
2533: -- Start MOAC
2534: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
2535: DELETE
2536: FROM OE_Credits_Iface_All
2537: WHERE order_source_id BETWEEN l_min_order_source_id and l_max_order_source_id
2538: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2539: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2540: AND orig_sys_line_ref IS NOT NULL