eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.CN_ROLE_PAY_GROUPS_PVT dependencies on CN_SRP_ROLES

Line 78: from cn_srp_roles

74:
75: -- get srp role assignment start and end dates
76: select start_date, end_date, salesrep_id
77: into l_srp_role_start_date, l_srp_role_end_date, l_salesrep_id
78: from cn_srp_roles
79: where srp_role_id = p_srp_role_id
80: and org_id = l_org_id;
81:
82: -- get intersection between srp_role and role_pay_group dates

Line 121: FROM cn_srp_roles

117: SELECT role_name into l_role_name
118: FROM jtf_rs_roles_tl
119: WHERE role_id =
120: (SELECT role_id
121: FROM cn_srp_roles
122: WHERE srp_role_id = p_srp_role_id
123: AND salesrep_id = l_salesrep_id)
124: AND language = USERENV('LANG');
125: fnd_message.set_name('CN', 'CN_SRP_OUTSIDE_PAYGRP_DATE');

Line 732: FROM cn_srp_roles

728: x_loading_status OUT NOCOPY VARCHAR2 ) IS
729:
730: CURSOR l_cur IS
731: SELECT srp_role_id
732: FROM cn_srp_roles
733: WHERE role_id = p_role_id and salesrep_id= p_salesrep_id and org_id=p_org_id;
734:
735: l_rec l_cur%ROWTYPE;
736:

Line 811: FROM cn_srp_roles

807: CURSOR get_roles (p_salesrep_id cn_salesreps.salesrep_id%TYPE,p_org_id cn_salesreps.org_id%TYPE) IS
808:
809: /*
810: SELECT role_id, srp_role_id,start_date, nvl(end_date,l_null_date) end_date,org_id
811: FROM cn_srp_roles
812: WHERE salesrep_id = p_salesrep_id and org_id=p_org_id; */
813:
814: --raj reddy for bug fix 8845580
815: SELECT sr.role_id, sr.srp_role_id,sr.start_date, nvl(sr.end_date,l_null_date) end_date,sr.org_id

Line 817: cn_srp_roles sr

813:
814: --raj reddy for bug fix 8845580
815: SELECT sr.role_id, sr.srp_role_id,sr.start_date, nvl(sr.end_date,l_null_date) end_date,sr.org_id
816: FROM jtf_rs_Salesreps s,
817: cn_srp_roles sr
818: WHERE sr.salesrep_id = s.salesrep_id
819: AND sr.salesrep_id = p_salesrep_id
820: AND sr.org_id = p_org_id
821: AND

Line 842: CURSOR l_srp_cur(l_role_id cn_roles.role_id%TYPE,l_org_id cn_srp_roles.org_id%TYPE) IS

838: WHERE role_id = p_role_id
839: AND salesrep_id = p_salesrep_id and org_id=p_org_id;
840:
841: /*
842: CURSOR l_srp_cur(l_role_id cn_roles.role_id%TYPE,l_org_id cn_srp_roles.org_id%TYPE) IS
843: SELECT srp_role_id,salesrep_id,start_date,end_date,org_id
844: FROM cn_srp_roles WHERE role_id = l_role_id and org_id=l_org_id;
845: */
846: --raj reddy for bug fix 8845580

Line 844: FROM cn_srp_roles WHERE role_id = l_role_id and org_id=l_org_id;

840:
841: /*
842: CURSOR l_srp_cur(l_role_id cn_roles.role_id%TYPE,l_org_id cn_srp_roles.org_id%TYPE) IS
843: SELECT srp_role_id,salesrep_id,start_date,end_date,org_id
844: FROM cn_srp_roles WHERE role_id = l_role_id and org_id=l_org_id;
845: */
846: --raj reddy for bug fix 8845580
847: CURSOR l_srp_cur(l_role_id cn_roles.role_id%TYPE,l_org_id cn_srp_roles.org_id%TYPE) IS
848: SELECT sr.srp_role_id,sr.salesrep_id,sr.start_date,sr.end_date,sr.org_id

Line 847: CURSOR l_srp_cur(l_role_id cn_roles.role_id%TYPE,l_org_id cn_srp_roles.org_id%TYPE) IS

843: SELECT srp_role_id,salesrep_id,start_date,end_date,org_id
844: FROM cn_srp_roles WHERE role_id = l_role_id and org_id=l_org_id;
845: */
846: --raj reddy for bug fix 8845580
847: CURSOR l_srp_cur(l_role_id cn_roles.role_id%TYPE,l_org_id cn_srp_roles.org_id%TYPE) IS
848: SELECT sr.srp_role_id,sr.salesrep_id,sr.start_date,sr.end_date,sr.org_id
849: FROM jtf_rs_Salesreps s,
850: cn_srp_roles sr
851: WHERE sr.salesrep_id = s.salesrep_id

Line 850: cn_srp_roles sr

846: --raj reddy for bug fix 8845580
847: CURSOR l_srp_cur(l_role_id cn_roles.role_id%TYPE,l_org_id cn_srp_roles.org_id%TYPE) IS
848: SELECT sr.srp_role_id,sr.salesrep_id,sr.start_date,sr.end_date,sr.org_id
849: FROM jtf_rs_Salesreps s,
850: cn_srp_roles sr
851: WHERE sr.salesrep_id = s.salesrep_id
852: AND sr.role_id = l_role_id
853: AND sr.org_id = l_org_id
854: AND

Line 1211: FROM cn_srp_roles

1207:
1208:
1209: CURSOR get_roles (p_salesrep_id cn_salesreps.salesrep_id%TYPE,p_org_id cn_salesreps.org_id%TYPE) IS
1210: SELECT role_id, srp_role_id,start_date, nvl(end_date,l_null_date) end_date,org_id
1211: FROM cn_srp_roles
1212: WHERE salesrep_id = p_salesrep_id and org_id=p_org_id;
1213:
1214: --Changed the cursor to fetch role_plans for the role_id passed
1215:

Line 1238: FROM cn_srp_roles

1234:
1235:
1236: CURSOR get_salesreps(l_role_id NUMBER,l_pay_group_id cn_pay_groups.pay_group_id%TYPE,l_org_id cn_pay_groups.org_id%TYPE) IS
1237: SELECT srp_role_id,salesrep_id,start_date,end_date,org_id
1238: FROM cn_srp_roles
1239: WHERE role_id = l_role_id
1240: AND salesrep_id IN (select salesrep_id from cn_srp_pay_groups where pay_group_id=l_pay_group_id)
1241: and org_id=l_org_id;
1242: