[Home] [Help]
223: AND a1.period_status in ('O', 'F')
224: AND a1.period_set_id = r.period_set_id
225: AND a1.period_type_id = r.period_type_id
226: AND a1.org_id = r.org_id
227: AND NOT exists ( SELECT * FROM cn_srp_intel_periods a2
228: WHERE a2.salesrep_id = l_srp_id AND
229: a2.period_id = a1.period_id AND
230: a2.org_id = a1.org_id);
231:
794: SELECT p.period_id,
795: greatest(p_start_date, p.start_date) start_date,
796: Decode(p_end_date, NULL, p.end_date,
797: Least(p_end_date, p.end_date)) end_date
798: FROM cn_srp_intel_periods p
799: WHERE p.salesrep_id = p_salesrep_id
800: AND p.org_id = l_org_id
801: AND (p_end_date IS NULL OR p.start_date <= p_end_date)
802: AND (p.end_date >= p_start_date);
972:
973: -- the check for valid insert and the actual insert row to role relations
974: -- is done by the public API... this hook calls the srp_plan assignment,
975: -- linking salesreps to comp plans, and it inserts into
976: -- cn_srp_intel_periods for intelligent calculation.
977:
978: -- for mark events
979: l_manager_flag VARCHAR2(1);
980: l_group_id NUMBER;
1351:
1352: END IF; -- clku, not TBH
1353: END IF; -- clku not null
1354:
1355: -- Insert into cn_srp_intel_periods for intelligent calculation
1356: ins_srp_intel_prd
1357: (p_salesrep_id => r.salesrep_id,
1358: p_start_date => p_start_date_active,
1359: p_end_date => p_end_date_active,
1624: IF (P_RETURN_CODE <> FND_API.G_RET_STS_SUCCESS ) THEN
1625: RAISE FND_API.G_EXC_ERROR;
1626: END IF;
1627:
1628: -- Insert into cn_srp_intel_periods for intelligent calculation
1629: ins_srp_intel_prd
1630: (p_salesrep_id => r.salesrep_id,
1631: p_start_date => p_start_date_active,
1632: p_end_date => p_end_date_active,