DBA Data[Home] [Help]

APPS.CN_SRP_PAYEE_ASSIGNS_PVT dependencies on CN_SRP_PLAN_ASSIGNS_ALL

Line 520: FROM cn_srp_quota_assigns_all sqa, cn_srp_plan_assigns_all spa

516:
517: -- get properties from given srp_quota_assign_id
518: SELECT spa.salesrep_id, sqa.org_id, sqa.quota_id, spa.comp_plan_id
519: INTO l_salesrep_id, l_org_id, l_quota_id, l_comp_plan_id
520: FROM cn_srp_quota_assigns_all sqa, cn_srp_plan_assigns_all spa
521: WHERE srp_quota_assign_id = p_srp_quota_assign_id
522: AND sqa.srp_plan_assign_id = spa.srp_plan_assign_id;
523:
524: Valid_Srp_Payee_Assigns

Line 768: FROM cn_srp_quota_assigns_all sqa, cn_srp_plan_assigns_all spa

764:
765: -- get properties from given srp_quota_assign_id
766: SELECT spa.comp_plan_id
767: INTO l_comp_plan_id
768: FROM cn_srp_quota_assigns_all sqa, cn_srp_plan_assigns_all spa
769: WHERE sqa.srp_quota_assign_id = l_old_rec.srp_quota_assign_id
770: AND sqa.srp_plan_assign_id = spa.srp_plan_assign_id;
771:
772: Valid_Srp_Payee_Assigns