DBA Data[Home] [Help]

APPS.CN_GET_TX_DATA_PUB dependencies on CN_ACC_PERIOD_STATUSES_V

Line 1335: FROM cn_acc_period_statuses_v

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

Line 1353: FROM cn_acc_period_statuses_v

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