APPS.CN_FORMULA_COMMON_PKG dependencies on DUAL

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

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

Line 1200: IF p_trx_group_code = 'INDIVIDUAL' THEN

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

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

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

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

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

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

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

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

3515: l_role_id NUMBER;
3516: l_org_id NUMBER;
3517: l_commission_line_id number;
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;