APPS.CN_FORMULA_COMMON_PKG dependencies on CN_PERIOD_STATUSES_ALL

Line 1449: cn_period_statuses_all b

1445: BEGIN
1446: select min(a.cal_period_id)
1447: INTO l_start_period_id
1448: from cn_cal_per_int_types_all a,
1449: cn_period_statuses_all b
1450: where (a.interval_type_id, a.org_id) = (select interval_type_id, org_id
1451: from cn_quotas_all
1452: where quota_id = p_quota_id)
1453: and a.interval_number = (select interval_number

Line 1461: from cn_period_statuses_all

1457: from cn_quotas_all
1458: where quota_id = p_quota_id))
1459: and a.cal_period_id = b.period_id
1460: and b.quarter_num = (select quarter_num
1461: from cn_period_statuses_all
1462: where period_id = p_period_id
1463: and org_id = (select org_id from cn_quotas_all where quota_id = p_quota_id));
1464:
1465: RETURN l_start_period_id;

Line 1474: cn_period_statuses_all b

1470: BEGIN
1471: select max(a.cal_period_id)
1472: INTO l_end_period_id
1473: from cn_cal_per_int_types_all a,
1474: cn_period_statuses_all b
1475: where (a.interval_type_id, a.org_id) = (select interval_type_id, org_id
1476: from cn_quotas_all
1477: where quota_id = p_quota_id)
1478: and a.interval_number = (select interval_number from cn_cal_per_int_types_all

Line 1485: from cn_period_statuses_all

1481: from cn_quotas_all
1482: where quota_id = p_quota_id))
1483: and a.cal_period_id = b.period_id
1484: and b.quarter_num = (select quarter_num
1485: from cn_period_statuses_all
1486: where period_id = p_period_id
1487: and org_id = (select org_id from cn_quotas_all where quota_id = p_quota_id));
1488:
1489: RETURN l_end_period_id;