DBA Data[Home] [Help]

APPS.CN_CALC_SUBLEDGER_PVT dependencies on CN_CAL_PER_INT_TYPES_ALL

Line 14: FROM cn_cal_per_int_types_all p2,

10: l_max_period_id NUMBER(15);
11: BEGIN
12: SELECT max(p2.cal_period_id)
13: INTO l_max_period_id
14: FROM cn_cal_per_int_types_all p2,
15: cn_srp_period_quotas_all cspq
16: WHERE p2.interval_type_id = (select interval_type_id
17: from cn_quotas_all
18: where quota_id = p_quota_id)

Line 20: from cn_cal_per_int_types_all p1

16: WHERE p2.interval_type_id = (select interval_type_id
17: from cn_quotas_all
18: where quota_id = p_quota_id)
19: AND p2.interval_number = (select p1.interval_number
20: from cn_cal_per_int_types_all p1
21: where p1.cal_period_id = p_period_id
22: and p1.org_id = g_org_id
23: and p1.interval_type_id = (select interval_type_id
24: from cn_quotas_all