APPS.CN_FORMULA_COMMON_PKG dependencies on CN_PERIOD_STATUSES_ALL

Line 1450: cn_period_statuses_all b

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

Line 1462: from cn_period_statuses_all

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

Line 1475: cn_period_statuses_all b

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

Line 1486: from cn_period_statuses_all

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