APPS.CN_MARK_EVENTS_PUB dependencies on CN_PERIOD_STATUSES_ALL

Line 8: select 1 from cn_period_statuses_all

4: G_PKG_NAME CONSTANT VARCHAR2(30) := 'CN_MARK_EVENTS_PUB';
5: G_FILE_NAME CONSTANT VARCHAR2(12) := 'cnpmkevb.pls';
6:
7: cursor check_period_id(p_period_id number, p_org_id number) is
8: select 1 from cn_period_statuses_all
9: where org_id = p_org_id
10: and period_id = p_period_id;
11:
12: cursor check_salesrep_id(p_salesrep_id number, p_period_id number, p_org_id number) is

Line 24: select 1 from cn_period_statuses_all

20: where org_id = p_org_id
21: and quota_id = p_quota_id;
22:
23: cursor check_date_in_period(p_period_id number, p_date date, p_org_id number) is
24: select 1 from cn_period_statuses_all
25: where period_id = p_period_id
26: and org_id = p_org_id
27: and p_date between start_date and end_date;
28: