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_SRP_PLAN_ASSIGNS_ALL

Line 1653: FROM cn_srp_plan_assigns_all spa,

1649: IN OUT p_latest_processed_date;
1650:
1651: ELSIF l_formula_type = 'B' THEN
1652: SELECT role.role_id INTO l_role_id
1653: FROM cn_srp_plan_assigns_all spa,
1654: cn_srp_roles role
1655: WHERE spa.srp_plan_assign_id = p_srp_plan_assign_id
1656: AND role.srp_role_id = spa.srp_role_id
1657: AND role.org_id = spa.org_id;

Line 1726: cn_srp_plan_assigns_all spa,

1722: prd.period_id,
1723: prd.process_all_flag,
1724: decode(prd.period_id, batch.period_id, batch.start_date, prd.start_date) start_date
1725: FROM cn_process_batches_all batch,
1726: cn_srp_plan_assigns_all spa,
1727: cn_srp_intel_periods_all prd
1728: WHERE batch.physical_batch_id = p_physical_batch_id
1729: AND prd.salesrep_id = batch.salesrep_id
1730: AND prd.period_id BETWEEN batch.period_id AND batch.end_period_id

Line 1750: from cn_srp_plan_assigns_all

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
1749: and qa.comp_plan_id = (select comp_plan_id
1750: from cn_srp_plan_assigns_all
1751: where srp_plan_assign_id = l_srp_plan_assign_id)
1752: and qa.quota_id = spq.quota_id
1753: and q.quota_id = spq.quota_id
1754: and q.incentive_type_code = 'COMMISSION'

Line 1787: FROM cn_srp_plan_assigns_all spa,

1783: inlv.end_period_id, inlv.end_date, inlv.quota_id, inlv.interval_type_id
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

Line 1815: FROM cn_srp_plan_assigns_all spa,

1811: WHERE csq.calc_sub_batch_id = l_calc_sub_batch_id))
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

Line 3522: FROM cn_srp_plan_assigns_all

3518: BEGIN
3519: SELECT cn_commission_headers_s.NEXTVAL INTO l_header_id FROM dual;
3520:
3521: SELECT role_id, org_id INTO l_role_id, l_org_id
3522: FROM cn_srp_plan_assigns_all
3523: WHERE srp_plan_assign_id = p_trx_rec.srp_plan_assign_id;
3524:
3525: INSERT INTO cn_commission_headers_all
3526: (commission_header_id, direct_salesrep_id, processed_date,