eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_FORMULA_COMMON_PKG dependencies on CN_CAL_PER_INT_TYPES_ALL

Line 1068: FROM cn_cal_per_int_types_all

1064: FROM cn_srp_period_quotas_all
1065: WHERE srp_plan_assign_id = p_srp_plan_assign_id
1066: AND quota_id = p_quota_id
1067: AND period_id = (SELECT MAX(cal_period_id)
1068: FROM cn_cal_per_int_types_all
1069: WHERE interval_type_id = l_interval_type_id
1070: AND cal_period_id < p_period_id
1071: AND org_id = l_org_id
1072: AND interval_number <> (SELECT interval_number

Line 1073: FROM cn_cal_per_int_types_all

1069: WHERE interval_type_id = l_interval_type_id
1070: AND cal_period_id < p_period_id
1071: AND org_id = l_org_id
1072: AND interval_number <> (SELECT interval_number
1073: FROM cn_cal_per_int_types_all
1074: WHERE interval_type_id = l_interval_type_id
1075: AND org_id = l_org_id
1076: AND cal_period_id = p_period_id));
1077:

Line 1097: FROM cn_cal_per_int_types_all ccpit,

1093: AND quota_id = csrq.source_quota_id
1094: AND srp_quota_assign_id = cspq.srp_quota_assign_id)
1095: AND cspq.period_id < p_period_id
1096: AND NOT exists (SELECT 1
1097: FROM cn_cal_per_int_types_all ccpit,
1098: cn_srp_period_quotas_all cspq2
1099: WHERE ccpit.org_id = l_org_id
1100: AND ccpit.cal_period_id > (SELECT MAX(period_id)
1101: FROM cn_srp_period_quotas_all

Line 1111: FROM cn_cal_per_int_types_all

1107: AND cspq2.quota_id = p_quota_id
1108: AND cspq2.period_id = ccpit.cal_period_id
1109: AND ccpit.interval_type_id = l_interval_type_id
1110: AND ccpit.interval_number <> (SELECT interval_number
1111: FROM cn_cal_per_int_types_all
1112: WHERE interval_type_id = l_interval_type_id
1113: AND cal_period_id = p_period_id
1114: AND org_id = l_org_id))
1115: ;

Line 1397: FROM cn_cal_per_int_types_all p2

1393: l_start_period_id NUMBER(15);
1394: BEGIN
1395: SELECT MIN(p2.cal_period_id)
1396: INTO l_start_period_id
1397: FROM cn_cal_per_int_types_all p2
1398: WHERE (p2.interval_type_id, p2.org_id, p2.interval_number) IN
1399: (SELECT p1.interval_type_id, p1.org_id, p1.interval_number
1400: FROM cn_cal_per_int_types_all p1,
1401: cn_quotas_all q

Line 1400: FROM cn_cal_per_int_types_all p1,

1396: INTO l_start_period_id
1397: FROM cn_cal_per_int_types_all p2
1398: WHERE (p2.interval_type_id, p2.org_id, p2.interval_number) IN
1399: (SELECT p1.interval_type_id, p1.org_id, p1.interval_number
1400: FROM cn_cal_per_int_types_all p1,
1401: cn_quotas_all q
1402: WHERE p1.cal_period_id = p_period_id
1403: AND q.quota_id = p_quota_id
1404: AND p1.org_id = q.org_id

Line 1420: FROM cn_cal_per_int_types_all p2

1416: l_end_period_id NUMBER(15);
1417: BEGIN
1418: SELECT MAX(p2.cal_period_id)
1419: INTO l_end_period_id
1420: FROM cn_cal_per_int_types_all p2
1421: WHERE (p2.interval_type_id, p2.org_id, p2.interval_number) IN
1422: (SELECT p1.interval_type_id, p1.org_id, p1.interval_number
1423: FROM cn_cal_per_int_types_all p1,
1424: cn_quotas_all q

Line 1423: FROM cn_cal_per_int_types_all p1,

1419: INTO l_end_period_id
1420: FROM cn_cal_per_int_types_all p2
1421: WHERE (p2.interval_type_id, p2.org_id, p2.interval_number) IN
1422: (SELECT p1.interval_type_id, p1.org_id, p1.interval_number
1423: FROM cn_cal_per_int_types_all p1,
1424: cn_quotas_all q
1425: WHERE p1.cal_period_id = p_period_id
1426: AND q.quota_id = p_quota_id
1427: AND p1.org_id = q.org_id

Line 1448: from cn_cal_per_int_types_all a,

1444: l_start_period_id NUMBER(15);
1445: BEGIN
1446: select min(a.cal_period_id)
1447: INTO l_start_period_id
1448: from cn_cal_per_int_types_all a,
1449: cn_period_statuses_all b
1450: where (a.interval_type_id, a.org_id) = (select interval_type_id, org_id
1451: from cn_quotas_all
1452: where quota_id = p_quota_id)

Line 1454: from cn_cal_per_int_types_all

1450: where (a.interval_type_id, a.org_id) = (select interval_type_id, org_id
1451: from cn_quotas_all
1452: where quota_id = p_quota_id)
1453: and a.interval_number = (select interval_number
1454: from cn_cal_per_int_types_all
1455: where cal_period_id = p_period_id
1456: and (interval_type_id, org_id) = (select interval_type_id, org_id
1457: from cn_quotas_all
1458: where quota_id = p_quota_id))

Line 1473: from cn_cal_per_int_types_all a,

1469: l_end_period_id NUMBER(15);
1470: BEGIN
1471: select max(a.cal_period_id)
1472: INTO l_end_period_id
1473: from cn_cal_per_int_types_all a,
1474: cn_period_statuses_all b
1475: where (a.interval_type_id, a.org_id) = (select interval_type_id, org_id
1476: from cn_quotas_all
1477: where quota_id = p_quota_id)

Line 1478: and a.interval_number = (select interval_number from cn_cal_per_int_types_all

1474: cn_period_statuses_all b
1475: where (a.interval_type_id, a.org_id) = (select interval_type_id, org_id
1476: from cn_quotas_all
1477: where quota_id = p_quota_id)
1478: and a.interval_number = (select interval_number from cn_cal_per_int_types_all
1479: where cal_period_id = p_period_id
1480: and (interval_type_id, org_id) = (select interval_type_id, org_id
1481: from cn_quotas_all
1482: where quota_id = p_quota_id))