APPS.CN_FORMULA_COMMON_PKG dependencies on CN_SRP_QUOTA_ASSIGNS_ALL

Line 622: FROM cn_srp_quota_assigns_all

618: g_comm_amount_table.DELETE;
619:
620: SELECT customized_flag
621: INTO l_customized_flag
622: FROM cn_srp_quota_assigns_all
623: WHERE srp_plan_assign_id = p_srp_plan_assign_id
624: AND quota_id = p_quota_id;
625:
626: IF (l_customized_flag = 'Y') then

Line 1085: FROM cn_srp_quota_assigns_all

1081: FROM cn_srp_rollover_quotas_all csrq,
1082: cn_srp_period_quotas_all cspq
1083: WHERE csrq.quota_id = p_quota_id
1084: AND csrq.srp_quota_assign_id = (SELECT srp_quota_assign_id
1085: FROM cn_srp_quota_assigns_all
1086: WHERE srp_plan_assign_id = p_srp_plan_assign_id
1087: AND quota_id = p_quota_id)
1088: AND cspq.salesrep_id = p_salesrep_id
1089: AND cspq.quota_id = csrq.source_quota_id

Line 3567: FROM cn_srp_quota_assigns_all sqa,

3563: return commission_line_id into l_commission_line_id;
3564:
3565: update cn_commission_lines_all cl
3566: set srp_payee_assign_id = (SELECT spa.srp_payee_assign_id
3567: FROM cn_srp_quota_assigns_all sqa,
3568: cn_srp_payee_assigns_all spa
3569: WHERE sqa.srp_plan_assign_id = cl.srp_plan_assign_id
3570: AND sqa.quota_id = cl.quota_id
3571: AND nvl(spa.delete_flag, 'N') <> 'Y'

Line 3744: FROM cn_srp_quota_assigns_all sqa,

3740: FROM cn_trx_factors_all tf
3741: WHERE tf.quota_rule_id = cl.quota_rule_id
3742: AND tf.trx_type = cl.trx_type),
3743: (srp_payee_assign_id) = (SELECT spa.srp_payee_assign_id
3744: FROM cn_srp_quota_assigns_all sqa,
3745: cn_srp_payee_assigns_all spa
3746: WHERE sqa.srp_plan_assign_id = cl.srp_plan_assign_id
3747: AND sqa.quota_id = cl.quota_id
3748: AND nvl(spa.delete_flag, 'N') <> 'Y'