APPS.CN_TRANSACTION_LOAD_PUB dependencies on CN_PERIOD_STATUSES_ALL

Line 1307: from cn_period_statuses_all

1303: /* verify that parameter start date is within an open acc period */
1304: l_count := 0;
1305: select count(*)
1306: into l_count
1307: from cn_period_statuses_all
1308: where period_status = 'O'
1309: and org_id = p_org_id
1310: and (period_set_id, period_type_id) =
1311: (select period_set_id, period_type_id

Line 1332: from cn_period_statuses_all

1328: /* verify that parameter end date is within an open acc period */
1329: l_count := 0;
1330: select count(*)
1331: into l_count
1332: from cn_period_statuses_all
1333: where period_status = 'O'
1334: and org_id = p_org_id
1335: and (period_set_id, period_type_id) =
1336: (select period_set_id, period_type_id