DBA Data[Home] [Help]

APPS.WF_NOTIFICATION dependencies on WF_LOOKUPS

Line 379: from WF_LOOKUPS

375: elsif (l_type = 'LOOKUP') then
376: begin
377: select MEANING
378: into l_text
379: from WF_LOOKUPS
380: where LOOKUP_TYPE = l_format
381: and LOOKUP_CODE = l_textv;
382: exception
383: when no_data_found then

Line 1509: -- LOOKUP type select meaning from wf_lookups.

1505: end if;
1506:
1507: -- Find displayed value of token depending on type
1508: if (not_attr_row.type = 'LOOKUP') then
1509: -- LOOKUP type select meaning from wf_lookups.
1510: begin
1511: select MEANING
1512: into value
1513: from WF_LOOKUPS

Line 1513: from WF_LOOKUPS

1509: -- LOOKUP type select meaning from wf_lookups.
1510: begin
1511: select MEANING
1512: into value
1513: from WF_LOOKUPS
1514: where LOOKUP_TYPE = not_attr_row.format
1515: and LOOKUP_CODE = not_attr_row.text_value;
1516: exception
1517: when no_data_found then

Line 1826: -- LOOKUP type select meaning from wf_lookups.

1822: if ((instr(local_text, '&'||not_attr_row.name)>0) OR (instr(local_text, '&'||not_attr_row.name)>0)) then
1823:
1824: -- Find displayed value of token depending on type
1825: if (not_attr_row.type = 'LOOKUP') then
1826: -- LOOKUP type select meaning from wf_lookups.
1827: begin
1828: select MEANING
1829: into value
1830: from WF_LOOKUPS

Line 1830: from WF_LOOKUPS

1826: -- LOOKUP type select meaning from wf_lookups.
1827: begin
1828: select MEANING
1829: into value
1830: from WF_LOOKUPS
1831: where LOOKUP_TYPE = not_attr_row.format
1832: and LOOKUP_CODE = not_attr_row.text_value;
1833: exception
1834: when no_data_found then