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.

[Home] [Help]

APPS.CN_FORMULA_COMMON_PKG dependencies on CN_QUOTA_ASSIGNS_ALL

Line 1745: cn_quota_assigns_all qa,

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

Line 1789: cn_quota_assigns_all qa,

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

Line 1817: cn_quota_assigns_all qa,

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