APPS.CN_FORMULA_COMMON_PKG dependencies on CN_SRP_PLAN_ASSIGNS_ALL

Line 1654: FROM cn_srp_plan_assigns_all spa,

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

Line 1727: cn_srp_plan_assigns_all spa,

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

Line 1751: from cn_srp_plan_assigns_all

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

Line 1788: FROM cn_srp_plan_assigns_all spa,

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

Line 1816: FROM cn_srp_plan_assigns_all spa,

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

Line 3551: FROM cn_srp_plan_assigns_all

3547: BEGIN
3548: SELECT cn_commission_headers_s.NEXTVAL INTO l_header_id FROM dual;
3549:
3550: SELECT role_id, org_id INTO l_role_id, l_org_id
3551: FROM cn_srp_plan_assigns_all
3552: WHERE srp_plan_assign_id = p_trx_rec.srp_plan_assign_id;
3553:
3554: INSERT INTO cn_commission_headers_all
3555: (commission_header_id, direct_salesrep_id, processed_date,