APPS.CN_FORMULA_COMMON_PKG dependencies on CN_SRP_QUOTA_ASSIGNS_ALL

Line 623: FROM cn_srp_quota_assigns_all

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

Line 1086: FROM cn_srp_quota_assigns_all

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

Line 3596: FROM cn_srp_quota_assigns_all sqa,

3592: return commission_line_id into l_commission_line_id;
3593:
3594: update cn_commission_lines_all cl
3595: set srp_payee_assign_id = (SELECT spa.srp_payee_assign_id
3596: FROM cn_srp_quota_assigns_all sqa,
3597: cn_srp_payee_assigns_all spa
3598: WHERE sqa.srp_plan_assign_id = cl.srp_plan_assign_id
3599: AND sqa.quota_id = cl.quota_id
3600: AND nvl(spa.delete_flag, 'N') <> 'Y'

Line 3773: FROM cn_srp_quota_assigns_all sqa,

3769: FROM cn_trx_factors_all tf
3770: WHERE tf.quota_rule_id = cl.quota_rule_id
3771: AND tf.trx_type = cl.trx_type),
3772: (srp_payee_assign_id) = (SELECT spa.srp_payee_assign_id
3773: FROM cn_srp_quota_assigns_all sqa,
3774: cn_srp_payee_assigns_all spa
3775: WHERE sqa.srp_plan_assign_id = cl.srp_plan_assign_id
3776: AND sqa.quota_id = cl.quota_id
3777: AND nvl(spa.delete_flag, 'N') <> 'Y'