APPS.CS_AUTOGEN_TASK_PVT dependencies on DUAL

Line 29: select sysdate + l_profile_respond_by into l_planned_end_date from dual;

25: If p_respond_by is not null and p_respond_by >= Sysdate Then
26: l_planned_end_date:= p_respond_by;
27:
28: ElsIf l_profile_respond_by is not null Then
29: select sysdate + l_profile_respond_by into l_planned_end_date from dual;
30:
31: Elsif p_planned_effort is not null and p_uom_code is not null then
32: l_planned_end_date := okc_time_util_pub.get_enddate(Sysdate,p_uom_code,p_planned_effort);
33: End If;

Line 47: select sysdate + l_profile_respond_by into l_planned_end_date from dual;

43: l_planned_end_date := okc_time_util_pub.get_enddate(p_resolve_by,p_uom_code,l_planned_effort);
44:
45: End IF;
46: Elsif l_profile_respond_by is not null Then
47: select sysdate + l_profile_respond_by into l_planned_end_date from dual;
48:
49: Elsif p_planned_effort is not null and p_uom_code is not null then
50: l_planned_end_date := okc_time_util_pub.get_enddate(Sysdate,p_uom_code,p_planned_effort);
51:

Line 58: select sysdate + l_profile_respond_by into l_planned_end_date from dual;

54: If p_resolve_by is not null and p_resolve_by >= Sysdate then
55: l_planned_end_date := p_resolve_by;
56:
57: elsif l_profile_respond_by is not null Then
58: select sysdate + l_profile_respond_by into l_planned_end_date from dual;
59:
60: Elsif p_planned_effort is not null and p_uom_code is not null then
61: l_planned_end_date := okc_time_util_pub.get_enddate(Sysdate,p_uom_code,p_planned_effort);
62: End if;