DBA Data[Home] [Help]

APPS.XLA_CONTROL_ACCOUNTS_PKG dependencies on XLA_AE_LINES

Line 362: UPDATE xla_ae_lines xal

358: IF p_ae_line_num IS NULL
359: THEN
360: --WARNING: This is 1 of 3 similar update statements
361: -- Ensure changes are propagated
362: UPDATE xla_ae_lines xal
363: SET xal.control_balance_flag = C_CONTROL_BALANCE_FLAG_PENDING
364: WHERE xal.ROWID IN
365: ( SELECT ael.ROWID
366: FROM xla_ae_headers aeh

Line 369: ,xla_ae_lines ael

365: ( SELECT ael.ROWID
366: FROM xla_ae_headers aeh
367: ,gl_ledgers xgl
368: ,xla_subledgers xsb
369: ,xla_ae_lines ael
370: ,gl_code_combinations gcc
371: WHERE aeh.ae_header_id = p_ae_header_id
372: AND aeh.application_id = p_application_id
373: AND aeh.balance_type_code = 'A'

Line 390: UPDATE xla_ae_lines xal

386: );
387: ELSE
388: --WARNING: This is 2 of 3 similar update statements
389: -- Ensure changes are propagated
390: UPDATE xla_ae_lines xal
391: SET xal.control_balance_flag = C_CONTROL_BALANCE_FLAG_PENDING
392: WHERE xal.ROWID IN
393: ( SELECT ael.ROWID
394: FROM xla_ae_headers aeh

Line 397: ,xla_ae_lines ael

393: ( SELECT ael.ROWID
394: FROM xla_ae_headers aeh
395: ,gl_ledgers xgl
396: ,xla_subledgers xsb
397: ,xla_ae_lines ael
398: ,gl_code_combinations gcc
399: WHERE aeh.ae_header_id = p_ae_header_id
400: AND aeh.application_id = p_application_id
401: AND aeh.balance_type_code = 'A'

Line 493: UPDATE xla_ae_lines xal

489: END IF;
490:
491: --WARNING: This is 3 of 3 similar update statements
492: -- Ensure changes are propagated
493: UPDATE xla_ae_lines xal
494: SET xal.control_balance_flag = C_CONTROL_BALANCE_FLAG_PENDING
495: WHERE xal.ROWID IN
496: ( SELECT ael.ROWID
497: FROM xla_ae_headers aeh

Line 500: ,xla_ae_lines ael

496: ( SELECT ael.ROWID
497: FROM xla_ae_headers aeh
498: ,gl_ledgers xgl
499: ,xla_subledgers xsb
500: ,xla_ae_lines ael
501: ,gl_code_combinations gcc
502: WHERE aeh.event_id = p_event_id
503: AND aeh.entity_id = p_entity_id
504: AND aeh.application_id = p_application_id