DBA Data[Home] [Help]

APPS.CS_KB_CONC_PROG_PKG dependencies on CS_KB_SET_USED_HISTS

Line 1252: FROM CS_KB_HISTORIES_B H, CS_KB_SET_USED_HISTS USED_HISTS

1248: WHILE (i IS NOT NULL) LOOP
1249:
1250: -- count
1251: SELECT count(H.HISTORY_ID) INTO v_used_count
1252: FROM CS_KB_HISTORIES_B H, CS_KB_SET_USED_HISTS USED_HISTS
1253: WHERE H.HISTORY_ID=USED_HISTS.HISTORY_ID AND
1254: USED_HISTS.SET_ID=set_record.set_id AND
1255: USED_HISTS.USED_TYPE=CS_KNOWLEDGE_PVT.G_PF AND
1256: ((current_date-H.entry_date)<=list_of_days(i));