APPS.CN_TRANSACTION_LOAD_PKG dependencies on CN_REPOSITORIES_ALL

Line 546: FROM cn_repositories_all

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

Line 1204: FROM cn_repositories_all

1200: WHERE period_status = 'O'
1201: AND org_id = p_org_id
1202: AND (period_set_id, period_type_id) =
1203: (SELECT period_set_id, period_type_id
1204: FROM cn_repositories_all
1205: WHERE org_id = p_org_id)
1206: AND l_end_date BETWEEN start_date AND end_date;
1207:
1208: IF (l_open_period = 0) THEN