APPS.OE_ELECMSGS_PVT dependencies on OE_PAYMENTS_IFACE_ALL

Line 2040: FROM OE_Payments_Iface_All

2036:
2037: -- Start MOAC
2038: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
2039: DELETE
2040: FROM OE_Payments_Iface_All
2041: WHERE order_source_id = p_order_source_id
2042: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2043: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2044: AND orig_sys_line_ref IS NULL

Line 2070: FROM OE_Payments_Iface_All

2066:
2067: -- Start MOAC
2068: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
2069: DELETE
2070: FROM OE_Payments_Iface_All
2071: WHERE order_source_id BETWEEN l_min_order_source_id AND l_max_order_source_id
2072: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2073: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2074: AND orig_sys_line_ref IS NULL

Line 2867: FROM OE_Payments_Iface_All

2863:
2864: -- Start MOAC
2865: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
2866: DELETE
2867: FROM OE_Payments_Iface_All
2868: WHERE order_source_id = p_order_source_id
2869: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2870: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2871: AND orig_sys_line_ref IS NOT NULL

Line 2897: FROM OE_Payments_Iface_All

2893:
2894: -- Start MOAC
2895: IF p_process_null_org_id = 'Y' AND (p_operating_unit IS NULL OR p_operating_unit = p_default_org_id) THEN
2896: DELETE
2897: FROM OE_Payments_Iface_All
2898: WHERE order_source_id BETWEEN l_min_order_source_id and l_max_order_source_id
2899: AND orig_sys_document_ref BETWEEN nvl(p_orig_sys_document_ref_from, orig_sys_document_ref)
2900: AND nvl(p_orig_sys_document_ref_to, orig_sys_document_ref)
2901: AND orig_sys_line_ref IS NOT NULL