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 1069: FROM cn_cal_per_int_types_all

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

Line 1074: FROM cn_cal_per_int_types_all

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

Line 1098: FROM cn_cal_per_int_types_all ccpit,

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

Line 1112: FROM cn_cal_per_int_types_all

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

Line 1398: FROM cn_cal_per_int_types_all p2

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

Line 1401: FROM cn_cal_per_int_types_all p1,

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

Line 1421: FROM cn_cal_per_int_types_all p2

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

Line 1424: FROM cn_cal_per_int_types_all p1,

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

Line 1449: from cn_cal_per_int_types_all a,

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

Line 1455: from cn_cal_per_int_types_all

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

Line 1474: from cn_cal_per_int_types_all a,

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

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

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