DBA Data[Home] [Help]

APPS.AR_DEFERRAL_REASONS_GRP dependencies on RA_INTERFACE_LINES

Line 10: g_om_context ra_interface_lines.interface_line_context%type :=

6: | Global Constants
7: +=======================================================================*/
8:
9: g_pkg_name CONSTANT VARCHAR2(30):= 'AR_DEFERREAL_REASONS_GRP';
10: g_om_context ra_interface_lines.interface_line_context%type :=
11: NVL(fnd_profile.value('ONT_SOURCE_CODE'),'###NOT_SET###');
12:
13: pg_debug VARCHAR2(1) := nvl(fnd_profile.value('AFLOG_ENABLED'), 'N');
14:

Line 278: FROM ra_interface_lines il

274: EXPIRATION_DATE = sysdate
275: WHERE interface_line_context = g_om_context
276: AND nvl(completed_flag, 'N') = 'N'
277: AND EXISTS (SELECT 'child exists'
278: FROM ra_interface_lines il
279: WHERE il.parent_line_id =
280: to_number(p_order_line.interface_line_attribute6)
281: AND il.interface_line_context = ic.interface_line_context
282: AND il.interface_line_attribute1 = ic.interface_line_attribute1