DBA Data[Home] [Help]

APPS.XLA_CONTROL_ACCOUNTS_PKG dependencies on XLA_AE_LINES

Line 361: UPDATE xla_ae_lines xal

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

Line 368: ,xla_ae_lines ael

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

Line 389: UPDATE xla_ae_lines xal

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

Line 396: ,xla_ae_lines ael

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

Line 492: UPDATE xla_ae_lines xal

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

Line 499: ,xla_ae_lines ael

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