APPS.HZ_MIXNM_DYNAMIC_PKG_GENERATOR dependencies on DUAL

Line 342: from dual

338: and aa.argument_name = party.column_name (+)
339: union all
340: select 'BANK_CODE' argument_name, 'VARCHAR2' data_type,
341: 30 data_length, null column_name
342: from dual
343: union all
344: select 'BANK_OR_BRANCH_NUMBER' argument_name, 'VARCHAR2' data_type,
345: 60 data_length, null column_name
346: from dual

Line 346: from dual

342: from dual
343: union all
344: select 'BANK_OR_BRANCH_NUMBER' argument_name, 'VARCHAR2' data_type,
345: 60 data_length, null column_name
346: from dual
347: union all
348: select 'BRANCH_CODE' argument_name, 'VARCHAR2' data_type,
349: 30 data_length, null column_name
350: from dual

Line 350: from dual

346: from dual
347: union all
348: select 'BRANCH_CODE' argument_name, 'VARCHAR2' data_type,
349: 30 data_length, null column_name
350: from dual
351: order by argument_name;
352:
353: l_entity_name VARCHAR2(30);
354:

Line 1182: li(' FROM dual');

1178: g_sep||''')+2)),');
1179: li(' ''Migration'',');
1180: Gen_CodeForWhoColumns('I','VALUE',g_indent||' ','Y');
1181: l('');
1182: li(' FROM dual');
1183: li(' WHERE NOT EXISTS (');
1184: li(' SELECT ''Y''');
1185: li(' FROM hz_win_source_exceps');
1186: li(' WHERE party_id = i_party_id1(i)');

Line 4786: li(' FROM dual');

4782: li(' ''U'',');
4783: li(' ''N'',');
4784: Gen_CodeForWhoColumns('I','VALUE',g_indent||' ','N');
4785: l('');
4786: li(' FROM dual');
4787: li(' UNION');
4788: li(' SELECT');
4789: li(' i_party_id(i),');
4790: li(' org_contact_id,');