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 1549: -- LOOKUP type select meaning from wf_lookups.

1545: end if;
1546:
1547: -- Find displayed value of token depending on type
1548: if (not_attr_row.type = 'LOOKUP') then
1549: -- LOOKUP type select meaning from wf_lookups.
1550: begin
1551: select MEANING
1552: into value
1553: from WF_LOOKUPS

Line 1553: from WF_LOOKUPS

1549: -- LOOKUP type select meaning from wf_lookups.
1550: begin
1551: select MEANING
1552: into value
1553: from WF_LOOKUPS
1554: where LOOKUP_TYPE = not_attr_row.format
1555: and LOOKUP_CODE = not_attr_row.text_value;
1556: exception
1557: when no_data_found then

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

1886: if ((instr(local_text, '&'||not_attr_row.name)>0) OR (instr(local_text, '&'||not_attr_row.name)>0)) then
1887:
1888: -- Find displayed value of token depending on type
1889: if (not_attr_row.type = 'LOOKUP') then
1890: -- LOOKUP type select meaning from wf_lookups.
1891: begin
1892: select MEANING
1893: into value
1894: from WF_LOOKUPS

Line 1894: from WF_LOOKUPS

1890: -- LOOKUP type select meaning from wf_lookups.
1891: begin
1892: select MEANING
1893: into value
1894: from WF_LOOKUPS
1895: where LOOKUP_TYPE = not_attr_row.format
1896: and LOOKUP_CODE = not_attr_row.text_value;
1897: exception
1898: when no_data_found then