APPS.CN_CALC_SUBMISSION_PVT dependencies on CN_PERIOD_STATUSES_ALL

Line 55: FROM cn_period_statuses_all ps1,

51: l_end_period_id NUMBER(15);
52: BEGIN
53: SELECT MAX(ps2.period_id)
54: INTO l_end_period_id
55: FROM cn_period_statuses_all ps1,
56: cn_period_statuses_all ps2
57: WHERE ps1.period_id = p_period_id
58: AND ps1.org_id = p_org_id
59: AND ps2.period_set_id = ps1.period_set_id

Line 56: cn_period_statuses_all ps2

52: BEGIN
53: SELECT MAX(ps2.period_id)
54: INTO l_end_period_id
55: FROM cn_period_statuses_all ps1,
56: cn_period_statuses_all ps2
57: WHERE ps1.period_id = p_period_id
58: AND ps1.org_id = p_org_id
59: AND ps2.period_set_id = ps1.period_set_id
60: AND ps2.org_id = p_org_id

Line 143: FROM cn_period_statuses_all

139: AND (p_sub_batch_rec.calc_sub_batch_id IS NULL OR calc_sub_batch_id <> p_sub_batch_rec.calc_sub_batch_id);
140:
141: CURSOR open_period_check(p_start_date DATE) IS
142: SELECT 1
143: FROM cn_period_statuses_all
144: WHERE (period_set_id, period_type_id) = (SELECT period_set_id, period_type_id FROM cn_repositories_all
145: WHERE org_id = p_sub_batch_rec.org_id)
146: AND period_status = 'O'
147: AND org_id = p_sub_batch_rec.org_id