APPS.OKC_TIME_RES_PVT dependencies on OKC_RESOLVED_TIMEVALUES

Line 1622: 'from okc_timevalues tve, okc_resolved_timevalues rtv ' ||

1618: /* Get all resolved timevalues */
1619:
1620: l_sql_string :=
1621: 'select rtv.id rtv_id ' ||
1622: 'from okc_timevalues tve, okc_resolved_timevalues rtv ' ||
1623: 'where rtv.tve_id = tve.id ' ||
1624: 'and rtv.datetime >= :p_end_date ' ||
1625: 'and tve.id in '|| l_list_of_tve_id ;
1626: open tve_id_csr for l_sql_string using p_end_date;

Line 1704: SELECT '1' from OKC_RESOLVED_TIMEVALUES

1700:
1701: -- Replaced name with seeded id to avoid transaltion issue - Bug 1683539
1702: -- Reed OKCSCHRULE - Contract Schedule Rule - Bug 1683539
1703: CURSOR Check_RTV_Tasks_csr (p_tve_id IN NUMBER, p_date IN DATE) IS
1704: SELECT '1' from OKC_RESOLVED_TIMEVALUES
1705: WHERE tve_id = p_tve_id AND
1706: datetime <= p_date
1707: UNION ALL
1708: SELECT '1' from OKC_RESOLVED_TIMEVALUES rtv, JTF_TASKS_B t, JTF_TASK_TYPES_VL tt

Line 1708: SELECT '1' from OKC_RESOLVED_TIMEVALUES rtv, JTF_TASKS_B t, JTF_TASK_TYPES_VL tt

1704: SELECT '1' from OKC_RESOLVED_TIMEVALUES
1705: WHERE tve_id = p_tve_id AND
1706: datetime <= p_date
1707: UNION ALL
1708: SELECT '1' from OKC_RESOLVED_TIMEVALUES rtv, JTF_TASKS_B t, JTF_TASK_TYPES_VL tt
1709: WHERE SOURCE_OBJECT_ID = rtv.id AND
1710: t.TASK_TYPE_ID = tt.TASK_TYPE_ID AND
1711: tve_id = p_tve_id AND
1712: tt.task_type_id = 23 AND

Line 1733: from okc_timevalues tve, okc_resolved_timevalues rtv

1729: x_return_status OUT NOCOPY VARCHAR2) IS
1730:
1731: CURSOR rtv_csr(p_tve_id IN NUMBER, p_date IN DATE) is
1732: select rtv.id rtv_id
1733: from okc_timevalues tve, okc_resolved_timevalues rtv
1734: where rtv.tve_id = tve.id
1735: and rtv.datetime >= p_date
1736: and tve.id = p_tve_id ;
1737: