APPS.CN_PERIOD_QUOTAS_PKG dependencies on CN_CAL_PER_INT_TYPES

Line 423: cn_cal_per_int_types cpit,

419: p.period_payment,
420: p.performance_goal
421: FROM cn_period_quotas p,
422: cn_acc_period_statuses_v cp,
423: cn_cal_per_int_types cpit,
424: cn_quotas cq
425: WHERE p.quota_id = p_quota_id
426: AND p.quota_id = cq.quota_id
427: AND cq.org_id = p.org_id

Line 445: cn_cal_per_int_types cpit,

441: cpit.interval_number interval_number,
442: p.period_year period_year
443: FROM cn_period_quotas p,
444: cn_acc_period_statuses_v cp,
445: cn_cal_per_int_types cpit,
446: cn_quotas cq
447: WHERE p.quota_id = p_quota_id
448: AND p.quota_id = cq.quota_id
449: AND p.period_id = cp.period_id

Line 679: FROM cn_cal_per_int_types

675: p_org_id NUMBER
676: )
677: IS
678: SELECT MAX (cal_period_id) max_cal_period_id
679: FROM cn_cal_per_int_types
680: WHERE interval_type_id = p_interval_type_id
681: AND cal_period_id < p_start_period_id
682: AND org_id = p_org_id
683: AND interval_number = (SELECT interval_number

Line 684: FROM cn_cal_per_int_types q

680: WHERE interval_type_id = p_interval_type_id
681: AND cal_period_id < p_start_period_id
682: AND org_id = p_org_id
683: AND interval_number = (SELECT interval_number
684: FROM cn_cal_per_int_types q
685: WHERE q.cal_period_id = p_start_period_id
686: AND q.interval_type_id = p_interval_type_id
687: AND q.org_id = p_org_id);
688:

Line 695: FROM cn_cal_per_int_types

691: p_start_period_id NUMBER,
692: p_org_id NUMBER)
693: IS
694: SELECT cal_period_id
695: FROM cn_cal_per_int_types
696: WHERE interval_type_id = p_interval_type_id
697: AND cal_period_id >= p_start_period_id
698: AND org_id = p_org_id
699: AND interval_number = (SELECT interval_number

Line 700: FROM cn_cal_per_int_types

696: WHERE interval_type_id = p_interval_type_id
697: AND cal_period_id >= p_start_period_id
698: AND org_id = p_org_id
699: AND interval_number = (SELECT interval_number
700: FROM cn_cal_per_int_types
701: WHERE cal_period_id = p_start_period_id
702: AND interval_type_id = p_interval_type_id
703: AND org_id = p_org_id);
704: BEGIN

Line 773: cn_cal_per_int_types cpit,

769: p.period_payment,
770: p.performance_goal
771: FROM cn_period_quotas p,
772: cn_acc_period_statuses_v cp,
773: cn_cal_per_int_types cpit,
774: cn_quotas cq
775: WHERE p.quota_id = x_quota_id
776: AND p.quota_id = cq.quota_id
777: AND p.period_id = cp.period_id

Line 798: cn_cal_per_int_types cpit,

794: cpit.interval_number interval_number,
795: p.period_year period_year
796: FROM cn_period_quotas p,
797: cn_acc_period_statuses_v cp,
798: cn_cal_per_int_types cpit,
799: cn_quotas cq
800: WHERE p.quota_id = x_quota_id
801: AND p.quota_id = cq.quota_id
802: AND p.period_id = cp.period_id