APPS.CN_TRANSACTION_LOAD_PUB dependencies on CN_REPOSITORIES_ALL

Line 1310: from cn_repositories_all

1306: where period_status = 'O'
1307: and org_id = p_org_id
1308: and (period_set_id, period_type_id) =
1309: (select period_set_id, period_type_id
1310: from cn_repositories_all
1311: where org_id = p_org_id)
1312: and p_start_date between start_date and end_date;
1313: IF (l_count = 0) THEN
1314: debugmsg('Loader : Parameter Start Date is not within an open acc period');

Line 1335: from cn_repositories_all

1331: where period_status = 'O'
1332: and org_id = p_org_id
1333: and (period_set_id, period_type_id) =
1334: (select period_set_id, period_type_id
1335: from cn_repositories_all
1336: where org_id = p_org_id)
1337: and p_end_date between start_date and end_date;
1338: IF (l_count = 0) THEN
1339: debugmsg('Loader : Parameter End Date is not within an open acc period');