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_QUOTA_ASSIGNS_ALL

Line 1744: cn_quota_assigns_all qa,

1740: l_period_id NUMBER) IS
1741: SELECT spq.quota_id,
1742: qa.quota_sequence
1743: FROM cn_srp_period_quotas_all spq,
1744: cn_quota_assigns_all qa,
1745: cn_quotas_all q
1746: WHERE spq.srp_plan_assign_id = l_srp_plan_assign_id
1747: AND spq.salesrep_id = l_salesrep_id
1748: AND spq.period_id = l_period_id

Line 1788: cn_quota_assigns_all qa,

1784: FROM (
1785: SELECT spa.srp_plan_assign_id srp_plan_assign_id, batch.salesrep_id salesrep_id, qa.quota_sequence quota_sequence,
1786: batch.end_period_id end_period_id, batch.end_date end_date, pe.quota_id quota_id, pe.interval_type_id interval_type_id
1787: FROM cn_srp_plan_assigns_all spa,
1788: cn_quota_assigns_all qa,
1789: cn_quotas_all pe,
1790: cn_process_batches_all batch
1791: WHERE batch.physical_batch_id = p_physical_batch_id
1792: AND batch.salesrep_id = spa.salesrep_id

Line 1816: cn_quota_assigns_all qa,

1812: UNION
1813: SELECT spa.srp_plan_assign_id srp_plan_assign_id, batch.salesrep_id salesrep_id, qa.quota_sequence quota_sequence,
1814: batch.end_period_id end_period_id, batch.end_date end_date, pe.quota_id quota_id, pe.interval_type_id interval_type_id
1815: FROM cn_srp_plan_assigns_all spa,
1816: cn_quota_assigns_all qa,
1817: cn_quotas_all pe,
1818: cn_process_batches_all batch
1819: WHERE batch.physical_batch_id = p_physical_batch_id
1820: AND batch.salesrep_id = spa.salesrep_id