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 3568: cn_srp_payee_assigns_all spa

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

Line 3745: cn_srp_payee_assigns_all spa

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