DBA Data[Home] [Help]

APPS.CN_GET_TX_DATA_PUB dependencies on CN_ACC_PERIOD_STATUSES_V

Line 1336: FROM cn_acc_period_statuses_v

1332: -- API Body Begin
1333: -- Check for the open periods
1334: SELECT count(1)
1335: INTO l_period_count
1336: FROM cn_acc_period_statuses_v
1337: WHERE trunc(p_newtx_rec.processed_date)
1338: BETWEEN start_date AND end_date
1339: AND period_status IN ('O','F')
1340: AND org_id = p_newtx_rec.org_id;

Line 1354: FROM cn_acc_period_statuses_v

1350: --
1351: BEGIN
1352: SELECT period_id
1353: INTO l_processed_period_id
1354: FROM cn_acc_period_statuses_v
1355: WHERE trunc(p_newtx_rec.processed_date)
1356: BETWEEN start_date AND end_date
1357: AND period_status IN ('O','F')
1358: AND org_id = p_newtx_rec.org_id;