DBA Data[Home] [Help]

APPS.CUG_GENERIC_WF_PKG dependencies on JTF_TASK_TYPES_VL

Line 1874: FROM jtf_task_types_vl

1870: IS
1871: CURSOR csr_task_type_id
1872: IS
1873: SELECT task_type_id
1874: FROM jtf_task_types_vl
1875: WHERE task_type_id = p_task_type_id
1876: AND (START_DATE_ACTIVE IS NULL OR
1877: to_number(to_char(START_DATE_ACTIVE, 'YYYYMMDD')) <= to_number(to_char(sysdate, 'YYYYMMDD')) ) AND
1878: (END_DATE_ACTIVE is NULL OR

Line 1914: FROM jtf_task_types_vl

1910: BEGIN
1911:
1912: p_return_status := 'S';
1913: SELECT name into l_task_name
1914: FROM jtf_task_types_vl
1915: WHERE task_type_id = p_task_type_id;
1916: WF_ENGINE.SetItemAttrText(
1917: itemtype => 'SERVEREQ',
1918: itemkey => p_itemkey,