DBA Data[Home] [Help]

APPS.CSF_DEBRIEF_PVT dependencies on CS_INCIDENTS_ALL_B

Line 3102: from cs_incidents_all_b ci_all,

3098: l_count number;
3099: l_count2 number;
3100: cursor c_counter is
3101: select count(*) --cs_ctr.name, cs_ctr_v.value_timestamp
3102: from cs_incidents_all_b ci_all,
3103: cs_counter_groups cs_grp,
3104: cs_counters cs_ctr,
3105: cs_counter_values cs_ctr_v,
3106: jtf_tasks_b jt_b

Line 3118: cs_incidents_all_b ci_all,

3114: and nvl(cs_ctr_v.value_timestamp,jt_b.creation_date - 1) < least(jt_b.creation_date,sysdate); -- changed for bug 3558815
3115:
3116: cursor c_counter2 is
3117: Select count(*) from
3118: cs_incidents_all_b ci_all,
3119: cs_counter_groups cs_grp,
3120: cs_counters cs_ctr,
3121: cs_counter_values cs_ctr_v,
3122: jtf_tasks_b jt_b