APPS.XLA_UPGRADE_PUB dependencies on XLA_UPG_LINE_CRITERIA_GT

Line 293: from xla_upg_line_criteria_gt xlgt

289: THEN
290: delete xla_ae_line_details xal
291: where (ae_header_id, ae_line_num) IN
292: (select xlgt.ae_header_id,ae_line_num
293: from xla_upg_line_criteria_gt xlgt
294: where xal.ae_header_id = xlgt.ae_header_id
295: and xal.ae_line_num = xlgt.ae_line_num);
296: END IF;
297: update xla_upg_line_criteria_gt xlgt

Line 297: update xla_upg_line_criteria_gt xlgt

293: from xla_upg_line_criteria_gt xlgt
294: where xal.ae_header_id = xlgt.ae_header_id
295: and xal.ae_line_num = xlgt.ae_line_num);
296: END IF;
297: update xla_upg_line_criteria_gt xlgt
298: set error_message_name = 'XLA_UPG_INVALID_CRITERIA'
299: where NOT EXISTS
300: (select 1
301: from xla_analytical_hdrs_b xanh

Line 383: XLA_UPG_LINE_CRITERIA_GT

379: ,analytical_detail_number_3
380: ,analytical_detail_number_4
381: ,analytical_detail_number_5
382: FROM
383: XLA_UPG_LINE_CRITERIA_GT
384: WHERE ERROR_MESSAGE_NAME IS NOT NULL
385: ) adv1
386: WHERE NOT exists ( SELECT 'x'
387: FROM xla_analytical_dtl_vals adv2

Line 529: XLA_UPG_LINE_CRITERIA_GT alcg, xla_analytical_dtl_vals adv

525: ,alcg.ae_header_id
526: ,alcg.ae_line_num
527:
528: FROM
529: XLA_UPG_LINE_CRITERIA_GT alcg, xla_analytical_dtl_vals adv
530: WHERE --Detail 1
531: NVL( alcg.analytical_detail_char_1
532: ,NVL( TO_CHAR( alcg.analytical_detail_date_1
533: ,'J'||'.'||'HH24MISS'