APPS.CN_TRANSACTION_LOAD_PUB dependencies on CN_PERIOD_STATUSES_ALL

Line 1305: from cn_period_statuses_all

1301: /* verify that parameter start date is within an open acc period */
1302: l_count := 0;
1303: select count(*)
1304: into l_count
1305: from cn_period_statuses_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

Line 1330: from cn_period_statuses_all

1326: /* verify that parameter end date is within an open acc period */
1327: l_count := 0;
1328: select count(*)
1329: into l_count
1330: from cn_period_statuses_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