APPS.CN_TRANSACTION_LOAD_PKG dependencies on CN_REPOSITORIES_ALL

Line 549: FROM cn_repositories_all

545: x_latest_processed_date DATE;
546: BEGIN
547: SELECT NVL(latest_processed_date, TO_DATE('01/01/1900', 'DD/MM/YYYY'))
548: INTO x_latest_processed_date
549: FROM cn_repositories_all
550: WHERE org_id = p_org_id;
551:
552: -- Commented this query to fix bug# 1772128
553: /*

Line 1208: FROM cn_repositories_all

1204: WHERE period_status = 'O'
1205: AND org_id = p_org_id
1206: AND (period_set_id, period_type_id) =
1207: (SELECT period_set_id, period_type_id
1208: FROM cn_repositories_all
1209: WHERE org_id = p_org_id)
1210: AND l_end_date BETWEEN start_date AND end_date;
1211:
1212: IF (l_open_period = 0) THEN