DBA Data[Home] [Help]

APPS.CS_KB_CONC_PROG_PKG dependencies on CS_KB_HISTORIES_B

Line 1401: FROM CS_KB_HISTORIES_B H, CS_KB_SET_USED_HISTS USED_HISTS

1397: WHILE (i IS NOT NULL) LOOP
1398:
1399: -- count
1400: SELECT count(H.HISTORY_ID) INTO v_used_count
1401: FROM CS_KB_HISTORIES_B H, CS_KB_SET_USED_HISTS USED_HISTS
1402: WHERE H.HISTORY_ID=USED_HISTS.HISTORY_ID AND
1403: USED_HISTS.SET_ID=set_record.set_id AND
1404: USED_HISTS.USED_TYPE=CS_KNOWLEDGE_PVT.G_PF AND
1405: ((current_date-H.entry_date)<=list_of_days(i));