APPS.CN_FORMULA_COMMON_PKG dependencies on CN_SRP_PAYEE_ASSIGNS_ALL

Line 198: cn_srp_payee_assigns_all payee,

194: null, --cl.attribute15
195: cl.org_id,
196: 0
197: FROM cn_commission_lines_all cl,
198: cn_srp_payee_assigns_all payee,
199: cn_quotas_all pe
200: WHERE cl.commission_line_id = p_commission_line_id
201: AND cl.quota_id = pe.quota_id
202: AND cl.srp_payee_assign_id IS NOT NULL

Line 3597: cn_srp_payee_assigns_all spa

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'
3601: AND sqa.srp_quota_assign_id = spa.srp_quota_assign_id

Line 3774: cn_srp_payee_assigns_all spa

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'
3778: AND sqa.srp_quota_assign_id = spa.srp_quota_assign_id