APPS.CN_ROLE_PMT_PLANS_PVT dependencies on CN_SRP_ROLES

Line 807: from cn_srp_roles sr,

803: /* CURSOR l_cur IS
804: select sr.srp_role_id srp_role_id,
805: nvl(srd.job_title_id, G_MISS_JOB_TITLE) job_title_id,
806: nvl(srd.plan_activate_status, 'NOT_PUSHED') push_status
807: from cn_srp_roles sr,
808: cn_srp_role_dtls srd
809: where role_id = p_role_id
810: and srd.role_model_id is NULL
811: -- CHANGED FOR MODELING IMPACT

Line 819: from cn_srp_roles

815: --To exclude 'TBH' category. Modified by Julia Huang on 4/7/2004 for bug 3560026.
816: /*
817: CURSOR l_cur IS
818: select *
819: from cn_srp_roles
820: where role_id = p_role_id
821: ;
822: */
823: CURSOR l_cur (l_org_id cn_pmt_plans.org_id%TYPE) IS

Line 825: from cn_srp_roles csr, cn_salesreps cs

821: ;
822: */
823: CURSOR l_cur (l_org_id cn_pmt_plans.org_id%TYPE) IS
824: select csr.*
825: from cn_srp_roles csr, cn_salesreps cs
826: where csr.role_id = p_role_id
827: and csr.salesrep_id = cs.salesrep_id
828: and csr.org_id = cs.org_id
829: and csr.org_id = l_org_id;

Line 916: from cn_srp_roles sr,

912: /* CURSOR l_cur IS
913: select sr.srp_role_id srp_role_id,
914: nvl(srd.job_title_id, G_MISS_JOB_TITLE) job_title_id,
915: nvl(srd.plan_activate_status, 'NOT_PUSHED') push_status
916: from cn_srp_roles sr,
917: cn_srp_role_dtls srd
918: where role_id = p_role_id
919: and srd.role_model_id is NULL
920: -- CHANGED FOR MODELING IMPACT

Line 925: from cn_srp_roles

921: and sr.srp_role_id = srd.srp_role_id(+);*/
922:
923: CURSOR l_cur (l_org_id cn_role_pmt_plans.org_id%TYPE) IS
924: select srp_role_id
925: from cn_srp_roles
926: where role_id = p_role_id
927: and org_id = l_org_id;
928:
929: l_rec l_cur%ROWTYPE;

Line 988: FROM cn_srp_roles

984: x_loading_status OUT NOCOPY VARCHAR2 ) IS
985:
986: CURSOR l_cur (l_org_id cn_role_pmt_plans.org_id%TYPE) IS
987: SELECT srp_role_id
988: FROM cn_srp_roles
989: WHERE role_id = p_role_id
990: AND org_id = l_org_id;
991:
992: l_rec l_cur%ROWTYPE;