APPS.XLA_TP_BALANCE_RPT_PKG dependencies on DUAL

Line 130: 'select NULL LEGAL_COMMERCIAL_NUMBER from dual where 1>2';

126: WHERE legislative_category = ''COMMERCIAL_LAW''
127: AND legal_entity_id = :P_LEGAL_ENTITY_ID';
128:
129: C_COMMERCIAL_NULL_QUERY VARCHAR2(8000) :=
130: 'select NULL LEGAL_COMMERCIAL_NUMBER from dual where 1>2';
131:
132: --------------------------------------------------------------------------------
133: -- constant for VAT_REGISTRATION details
134: --------------------------------------------------------------------------------

Line 144: 'select NULL LEGAL_VAT_REGISTRATION_NUMBER from dual where 1>2';

140: AND xetbp.MAIN_ESTABLISHMENT_FLAG = ''Y''
141: AND xetbp.LEGAL_ENTITY_ID = :P_LEGAL_ENTITY_ID' ;
142:
143: C_VAT_REGISTRATION_NULL_QUERY VARCHAR2(8000) :=
144: 'select NULL LEGAL_VAT_REGISTRATION_NUMBER from dual where 1>2';
145:
146:
147: C_QUALIFIED_SEGMENT CONSTANT VARCHAR2(1000) :=
148: ' ,$alias_balancing_segment$ BALANCING_SEGMENT

Line 1473: from dual

1469: END IF;
1470: --bug-11666797
1471: select count(1)
1472: into l_bal_err_count
1473: from dual
1474: where exists (
1475: select 1
1476: from xla_ae_lines xal
1477: , xla_report_balances_gt gt