APPS.OE_ELECMSGS_PVT dependencies on OE_PRICE_ADJS_IFACE_ALL

Line 1893: FROM OE_Price_Adjs_Iface_All

1889:
1890: -- Start MOAC
1891: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
1892: DELETE
1893: FROM OE_Price_Adjs_Iface_All
1894: WHERE order_source_id = p_order_source_id
1895: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
1896: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1897: AND orig_sys_line_ref IS NULL

Line 1923: FROM OE_Price_Adjs_Iface_All

1919:
1920: -- Start MOAC
1921: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
1922: DELETE
1923: FROM OE_Price_Adjs_Iface_All
1924: WHERE order_source_id BETWEEN l_min_order_source_id AND l_max_order_source_id
1925: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
1926: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
1927: AND orig_sys_line_ref IS NULL

Line 2650: FROM OE_Price_Adjs_Iface_All

2646:
2647: -- Start MOAC
2648: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
2649: DELETE
2650: FROM OE_Price_Adjs_Iface_All
2651: WHERE order_source_id = p_order_source_id
2652: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2653: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2654: AND orig_sys_line_ref IS NOT NULL

Line 2680: FROM OE_Price_Adjs_Iface_All

2676:
2677: -- Start MOAC
2678: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
2679: DELETE
2680: FROM OE_Price_Adjs_Iface_All
2681: WHERE order_source_id BETWEEN l_min_order_source_id and l_max_order_source_id
2682: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2683: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2684: AND orig_sys_line_ref IS NOT NULL