DBA Data[Home] [Help]

APPS.CN_FORMULA_COMMON_PKG dependencies on CN_REPOSITORIES_ALL

Line 1859: FROM cn_repositories_all

1855:
1856: -- for maintaining cn_repositories.latest_processed_date
1857: SELECT nvl(latest_processed_date, to_date('01/01/1900', 'DD/MM/YYYY'))
1858: INTO l_current_processed_date
1859: FROM cn_repositories_all
1860: WHERE org_id = l_org_id;
1861:
1862: g_refresh_flag := 'Y';
1863:

Line 2165: UPDATE cn_repositories_all

2161: commit;
2162: END IF;
2163:
2164: -- for maintaining cn_repositories.latest_processed_date
2165: UPDATE cn_repositories_all
2166: SET latest_processed_date = l_current_processed_date
2167: WHERE latest_processed_date < l_current_processed_date
2168: AND org_id = l_org_id;
2169: