APPS.HZ_MIXNM_DYNAMIC_PKG_GENERATOR dependencies on DUAL

Line 141: FROM DUAL;

137: l_frmt_actual_content_source := p_actual_content_source;
138:
139: SELECT REPLACE(l_frmt_actual_content_source,':','_COLON_')
140: INTO l_frmt_actual_content_source
141: FROM DUAL;
142:
143: SELECT REPLACE(l_frmt_actual_content_source,'.','_PERIOD_')
144: INTO l_frmt_actual_content_source
145: FROM DUAL;

Line 145: FROM DUAL;

141: FROM DUAL;
142:
143: SELECT REPLACE(l_frmt_actual_content_source,'.','_PERIOD_')
144: INTO l_frmt_actual_content_source
145: FROM DUAL;
146:
147: SELECT REPLACE(l_frmt_actual_content_source,'-','_HYPHEN_')
148: INTO l_frmt_actual_content_source
149: FROM DUAL;

Line 149: FROM DUAL;

145: FROM DUAL;
146:
147: SELECT REPLACE(l_frmt_actual_content_source,'-','_HYPHEN_')
148: INTO l_frmt_actual_content_source
149: FROM DUAL;
150:
151: --Alias cannot be more than 30 characters (including d_ ).
152: --Trucating the formated value and Concatenating with rownum at the end.
153: IF length(l_frmt_actual_content_source) > 28 THEN

Line 424: from dual

420: and aa.argument_name = party.column_name (+)
421: union all
422: select 'BANK_CODE' argument_name, 'VARCHAR2' data_type,
423: 30 data_length, null column_name
424: from dual
425: union all
426: select 'BANK_OR_BRANCH_NUMBER' argument_name, 'VARCHAR2' data_type,
427: 60 data_length, null column_name
428: from dual

Line 428: from dual

424: from dual
425: union all
426: select 'BANK_OR_BRANCH_NUMBER' argument_name, 'VARCHAR2' data_type,
427: 60 data_length, null column_name
428: from dual
429: union all
430: select 'BRANCH_CODE' argument_name, 'VARCHAR2' data_type,
431: 30 data_length, null column_name
432: from dual

Line 432: from dual

428: from dual
429: union all
430: select 'BRANCH_CODE' argument_name, 'VARCHAR2' data_type,
431: 30 data_length, null column_name
432: from dual
433: order by argument_name;
434:
435: l_entity_name VARCHAR2(30);
436:

Line 1268: li(' FROM dual');

1264: g_sep||''')+2)),');
1265: li(' ''Migration'',');
1266: Gen_CodeForWhoColumns('I','VALUE',g_indent||' ','Y');
1267: l('');
1268: li(' FROM dual');
1269: li(' WHERE NOT EXISTS (');
1270: li(' SELECT ''Y''');
1271: li(' FROM hz_win_source_exceps');
1272: li(' WHERE party_id = i_party_id1(i)');

Line 4954: li(' FROM dual');

4950: li(' ''U'',');
4951: li(' ''N'',');
4952: Gen_CodeForWhoColumns('I','VALUE',g_indent||' ','N');
4953: l('');
4954: li(' FROM dual');
4955: li(' UNION');
4956: li(' SELECT');
4957: li(' i_party_id(i),');
4958: li(' org_contact_id,');