APPS.CN_FORMULA_COMMON_PKG dependencies on DUAL

Line 1132: IF allowing no prior adjustment, plan element with individual and accumulative

1128: p_quota_id, p_period_id );
1129: END IF;
1130:
1131: /******************************************************************************
1132: IF allowing no prior adjustment, plan element with individual and accumulative
1133: setting can be calculated incrementally.
1134: ******************************************************************************/
1135: IF (nvl(cn_system_parameters.value('CN_PRIOR_ADJUSTMENT', l_org_id), 'N') = 'N' ) THEN
1136: l_incremental_flag := 'Y';

Line 1201: IF p_trx_group_code = 'INDIVIDUAL' THEN

1197: IF p_calc_type = 'COMMISSION' THEN
1198: IF p_process_all_flag = 'Y' THEN
1199: IF p_intel_calc_flag = 'N' THEN
1200: -- need to sum the trx before p_start_date to get ptd
1201: IF p_trx_group_code = 'INDIVIDUAL' THEN
1202: SELECT
1203: SUM(line.input_achieved), SUM(line.output_achieved),
1204: SUM(line.perf_achieved), SUM(line.commission_amount)
1205: INTO l_input_achieved, l_output_achieved,

Line 1250: -- case3 : IF l_incremental_flag = 'Y' and trx_group_code = 'INDIVIDUAL'

1246: -- itd = itd -ptd, ptd initialized to 0
1247: -- because group by plan element always do a bulk group function
1248: -- when it reaches the end of interval.
1249:
1250: -- case3 : IF l_incremental_flag = 'Y' and trx_group_code = 'INDIVIDUAL'
1251: -- itd = itd, ptd = ptd
1252: IF l_incremental_flag = 'Y' AND p_trx_group_code = 'INDIVIDUAL' THEN
1253: cn_message_pkg.debug('p_trx_group_code: ' || p_trx_group_code );
1254:

Line 1252: IF l_incremental_flag = 'Y' AND p_trx_group_code = 'INDIVIDUAL' THEN

1248: -- when it reaches the end of interval.
1249:
1250: -- case3 : IF l_incremental_flag = 'Y' and trx_group_code = 'INDIVIDUAL'
1251: -- itd = itd, ptd = ptd
1252: IF l_incremental_flag = 'Y' AND p_trx_group_code = 'INDIVIDUAL' THEN
1253: cn_message_pkg.debug('p_trx_group_code: ' || p_trx_group_code );
1254:
1255: SELECT nvl(quota.input_achieved_itd,0), Nvl( quota.input_achieved_ptd, 0),
1256: nvl(quota.output_achieved_itd,0), Nvl(quota.output_achieved_ptd, 0),

Line 1306: -- because bonus type formula are guaranteed to be NON-cumulative, INDIVIDUAL, NON-itd

1302: cn_message_pkg.debug('--x_commission_payed_ptd: ' || x_commission_payed_ptd );
1303:
1304: ELSIF p_calc_type = 'BONUS' THEN
1305: -- do nothing since we already initialize ptd =0 and itd = itd - ptd
1306: -- because bonus type formula are guaranteed to be NON-cumulative, INDIVIDUAL, NON-itd
1307: NULL;
1308: END IF;
1309:
1310: if (FND_LOG.LEVEL_PROCEDURE >= FND_LOG.G_CURRENT_RUNTIME_LEVEL ) then

Line 3548: SELECT cn_commission_headers_s.NEXTVAL INTO l_header_id FROM dual;

3544: l_role_id NUMBER;
3545: l_org_id NUMBER;
3546: l_commission_line_id number;
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;