APPS.CN_TRANSACTION_LOAD_PUB dependencies on CN_REPOSITORIES_ALL

Line 1312: from cn_repositories_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
1312: from cn_repositories_all
1313: where org_id = p_org_id)
1314: and p_start_date between start_date and end_date;
1315: IF (l_count = 0) THEN
1316: debugmsg('Loader : Parameter Start Date is not within an open acc period');

Line 1337: from cn_repositories_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
1337: from cn_repositories_all
1338: where org_id = p_org_id)
1339: and p_end_date between start_date and end_date;
1340: IF (l_count = 0) THEN
1341: debugmsg('Loader : Parameter End Date is not within an open acc period');