[Home] [Help]
8:
9: CURSOR l_start_date_csr IS
10:
11: SELECT start_date
12: FROM cn_period_statuses_all
13: WHERE period_id = p_period_id
14: AND ((org_id = p_org_id) OR (org_id IS NULL AND p_org_id IS NULL));
15:
16: BEGIN
39:
40: CURSOR l_end_date_csr IS
41:
42: SELECT end_date
43: FROM cn_period_statuses_all
44: WHERE period_id = p_period_id
45: AND ((org_id = p_org_id) OR (org_id IS NULL AND p_org_id IS NULL));
46:
47: BEGIN