APPS.OE_ELECMSGS_PVT dependencies on OE_PRICE_ATTS_IFACE_ALL

Line 1966: FROM OE_Price_Atts_Iface_All

1962:
1963: -- Start MOAC
1964: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
1965: DELETE
1966: FROM OE_Price_Atts_Iface_All
1967: WHERE order_source_id = p_order_source_id
1968: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
1969: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1970: AND orig_sys_line_ref IS NULL

Line 1996: FROM OE_Price_Atts_Iface_All

1992:
1993: -- Start MOAC
1994: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
1995: DELETE
1996: FROM OE_Price_Atts_Iface_All
1997: WHERE order_source_id BETWEEN l_min_order_source_id and l_max_order_source_id
1998: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
1999: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2000: AND orig_sys_line_ref IS NULL

Line 2722: FROM OE_Price_Atts_Iface_All

2718:
2719: -- Start MOAC
2720: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
2721: DELETE
2722: FROM OE_Price_Atts_Iface_All
2723: WHERE order_source_id = p_order_source_id
2724: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2725: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2726: AND orig_sys_line_ref IS NOT NULL

Line 2752: FROM OE_Price_Atts_Iface_All

2748:
2749: -- Start MOAC
2750: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
2751: DELETE
2752: FROM OE_Price_Atts_Iface_All
2753: WHERE order_source_id BETWEEN l_min_order_source_id and l_max_order_source_id
2754: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2755: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2756: AND orig_sys_line_ref IS NOT NULL