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_SRP_PAYGROUP_PUB dependencies on CN_PAY_GROUPS

Line 104: from cn_pay_groups

100:
101: -- get pay groups start and end dates
102: select start_date, end_date
103: into l_pg_start_date, l_pg_end_date
104: from cn_pay_groups
105: where pay_group_id = l_pay_group_id;
106:
107: -- get intersection with pay group start and end dates
108: get_date_range_intersect(

Line 223: l_pay_group_name cn_pay_groups.name%TYPE;

219: l_salesrep_id cn_srp_pay_groups.salesrep_id%TYPE;
220: l_null_date CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');
221: l_status VARCHAR2(1);
222:
223: l_pay_group_name cn_pay_groups.name%TYPE;
224: l_create_rec cn_srp_paygroup_pvt.paygroup_assign_rec;
225:
226: CURSOR get_pay_group_id_cur IS
227: SELECT pay_group_id

Line 228: FROM cn_pay_groups_all

224: l_create_rec cn_srp_paygroup_pvt.paygroup_assign_rec;
225:
226: CURSOR get_pay_group_id_cur IS
227: SELECT pay_group_id
228: FROM cn_pay_groups_all
229: WHERE name = p_paygroup_assign_rec.pay_group_name
230: AND org_id = l_org_id;
231: l_get_pay_group_id_rec get_pay_group_id_cur%ROWTYPE;
232:

Line 690: FROM cn_pay_groups_all

686: l_bind_data_id NUMBER;
687:
688: CURSOR get_pay_group_id_cur(p_name VARCHAR2, p_org_id NUMBER) IS
689: SELECT pay_group_id
690: FROM cn_pay_groups_all
691: WHERE name = p_name
692: AND org_id = p_org_id;
693: l_old_pay_group_id cn_pay_groups.pay_group_id%TYPE;
694:

Line 693: l_old_pay_group_id cn_pay_groups.pay_group_id%TYPE;

689: SELECT pay_group_id
690: FROM cn_pay_groups_all
691: WHERE name = p_name
692: AND org_id = p_org_id;
693: l_old_pay_group_id cn_pay_groups.pay_group_id%TYPE;
694:
695: CURSOR get_srp_pay_group_id_cur (
696: c_salesrep_id cn_srp_pay_groups.salesrep_id%TYPE,
697: c_pay_group_id cn_srp_pay_groups.pay_group_id%TYPE,

Line 1295: l_pay_group_name cn_pay_groups.name%TYPE;

1291: l_salesrep_type cn_salesreps.type%TYPE;
1292: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
1293: l_org_id cn_salesreps.org_id%TYPE;
1294: l_emp_num cn_salesreps.employee_number%TYPE;
1295: l_pay_group_name cn_pay_groups.name%TYPE;
1296: l_pay_group_id cn_pay_groups.pay_group_id%TYPE;
1297: l_pg_start_date cn_pay_groups.start_date%TYPE;
1298: l_pg_end_date cn_pay_groups.end_date%TYPE;
1299: l_srp_start_date cn_srp_roles.start_date%TYPE;

Line 1296: l_pay_group_id cn_pay_groups.pay_group_id%TYPE;

1292: l_salesrep_id cn_salesreps.salesrep_id%TYPE;
1293: l_org_id cn_salesreps.org_id%TYPE;
1294: l_emp_num cn_salesreps.employee_number%TYPE;
1295: l_pay_group_name cn_pay_groups.name%TYPE;
1296: l_pay_group_id cn_pay_groups.pay_group_id%TYPE;
1297: l_pg_start_date cn_pay_groups.start_date%TYPE;
1298: l_pg_end_date cn_pay_groups.end_date%TYPE;
1299: l_srp_start_date cn_srp_roles.start_date%TYPE;
1300: l_srp_end_date cn_pay_groups.end_date%TYPE;

Line 1297: l_pg_start_date cn_pay_groups.start_date%TYPE;

1293: l_org_id cn_salesreps.org_id%TYPE;
1294: l_emp_num cn_salesreps.employee_number%TYPE;
1295: l_pay_group_name cn_pay_groups.name%TYPE;
1296: l_pay_group_id cn_pay_groups.pay_group_id%TYPE;
1297: l_pg_start_date cn_pay_groups.start_date%TYPE;
1298: l_pg_end_date cn_pay_groups.end_date%TYPE;
1299: l_srp_start_date cn_srp_roles.start_date%TYPE;
1300: l_srp_end_date cn_pay_groups.end_date%TYPE;
1301: l_start_date cn_srp_pay_groups.start_date%TYPE;

Line 1298: l_pg_end_date cn_pay_groups.end_date%TYPE;

1294: l_emp_num cn_salesreps.employee_number%TYPE;
1295: l_pay_group_name cn_pay_groups.name%TYPE;
1296: l_pay_group_id cn_pay_groups.pay_group_id%TYPE;
1297: l_pg_start_date cn_pay_groups.start_date%TYPE;
1298: l_pg_end_date cn_pay_groups.end_date%TYPE;
1299: l_srp_start_date cn_srp_roles.start_date%TYPE;
1300: l_srp_end_date cn_pay_groups.end_date%TYPE;
1301: l_start_date cn_srp_pay_groups.start_date%TYPE;
1302: l_end_date cn_srp_pay_groups.start_date%TYPE;

Line 1300: l_srp_end_date cn_pay_groups.end_date%TYPE;

1296: l_pay_group_id cn_pay_groups.pay_group_id%TYPE;
1297: l_pg_start_date cn_pay_groups.start_date%TYPE;
1298: l_pg_end_date cn_pay_groups.end_date%TYPE;
1299: l_srp_start_date cn_srp_roles.start_date%TYPE;
1300: l_srp_end_date cn_pay_groups.end_date%TYPE;
1301: l_start_date cn_srp_pay_groups.start_date%TYPE;
1302: l_end_date cn_srp_pay_groups.start_date%TYPE;
1303: l_source_id cn_salesreps.source_id%TYPE;
1304:

Line 1353: from cn_pay_groups_all

1349: AND org_id = l_org_id;
1350:
1351: select name
1352: into l_pay_group_name
1353: from cn_pay_groups_all
1354: where pay_group_id = l_pay_group_id;
1355:
1356: l_start_date := NULL;
1357: l_end_date := NULL;

Line 1497: l_pay_group_name_old cn_pay_groups.name%TYPE;

1493: l_count_srp_pay_group NUMBER;
1494: l_salesrep_type_old cn_salesreps.type%TYPE;
1495: l_salesrep_id_old cn_salesreps.salesrep_id%TYPE;
1496: l_emp_num_old cn_salesreps.employee_number%TYPE;
1497: l_pay_group_name_old cn_pay_groups.name%TYPE;
1498: l_pay_group_id_old cn_pay_groups.pay_group_id%TYPE;
1499: l_role_id_old cn_roles.role_id%TYPE;
1500: l_start_date_old cn_srp_pay_groups.start_date%TYPE;
1501: l_end_date_old cn_srp_pay_groups.start_date%TYPE;

Line 1498: l_pay_group_id_old cn_pay_groups.pay_group_id%TYPE;

1494: l_salesrep_type_old cn_salesreps.type%TYPE;
1495: l_salesrep_id_old cn_salesreps.salesrep_id%TYPE;
1496: l_emp_num_old cn_salesreps.employee_number%TYPE;
1497: l_pay_group_name_old cn_pay_groups.name%TYPE;
1498: l_pay_group_id_old cn_pay_groups.pay_group_id%TYPE;
1499: l_role_id_old cn_roles.role_id%TYPE;
1500: l_start_date_old cn_srp_pay_groups.start_date%TYPE;
1501: l_end_date_old cn_srp_pay_groups.start_date%TYPE;
1502: l_ovn_old cn_srp_pay_groups.object_version_number%TYPE;

Line 1513: l_pay_group_name_new cn_pay_groups.name%TYPE;

1509: delrec CN_Srp_PayGroup_PVT.PayGroup_assign_rec;
1510: l_salesrep_type_new cn_salesreps.type%TYPE;
1511: l_salesrep_id_new cn_salesreps.salesrep_id%TYPE;
1512: l_emp_num_new cn_salesreps.employee_number%TYPE;
1513: l_pay_group_name_new cn_pay_groups.name%TYPE;
1514: l_pay_group_id_new cn_pay_groups.pay_group_id%TYPE;
1515: l_pp_start_date_new cn_pay_groups.start_date%TYPE;
1516: l_pp_end_date_new cn_pay_groups.end_date%TYPE;
1517: l_srp_start_date_new cn_srp_roles.start_date%TYPE;

Line 1514: l_pay_group_id_new cn_pay_groups.pay_group_id%TYPE;

1510: l_salesrep_type_new cn_salesreps.type%TYPE;
1511: l_salesrep_id_new cn_salesreps.salesrep_id%TYPE;
1512: l_emp_num_new cn_salesreps.employee_number%TYPE;
1513: l_pay_group_name_new cn_pay_groups.name%TYPE;
1514: l_pay_group_id_new cn_pay_groups.pay_group_id%TYPE;
1515: l_pp_start_date_new cn_pay_groups.start_date%TYPE;
1516: l_pp_end_date_new cn_pay_groups.end_date%TYPE;
1517: l_srp_start_date_new cn_srp_roles.start_date%TYPE;
1518: l_srp_end_date_new cn_srp_roles.end_date%TYPE;

Line 1515: l_pp_start_date_new cn_pay_groups.start_date%TYPE;

1511: l_salesrep_id_new cn_salesreps.salesrep_id%TYPE;
1512: l_emp_num_new cn_salesreps.employee_number%TYPE;
1513: l_pay_group_name_new cn_pay_groups.name%TYPE;
1514: l_pay_group_id_new cn_pay_groups.pay_group_id%TYPE;
1515: l_pp_start_date_new cn_pay_groups.start_date%TYPE;
1516: l_pp_end_date_new cn_pay_groups.end_date%TYPE;
1517: l_srp_start_date_new cn_srp_roles.start_date%TYPE;
1518: l_srp_end_date_new cn_srp_roles.end_date%TYPE;
1519: l_start_date_new cn_srp_pay_groups.start_date%TYPE;

Line 1516: l_pp_end_date_new cn_pay_groups.end_date%TYPE;

1512: l_emp_num_new cn_salesreps.employee_number%TYPE;
1513: l_pay_group_name_new cn_pay_groups.name%TYPE;
1514: l_pay_group_id_new cn_pay_groups.pay_group_id%TYPE;
1515: l_pp_start_date_new cn_pay_groups.start_date%TYPE;
1516: l_pp_end_date_new cn_pay_groups.end_date%TYPE;
1517: l_srp_start_date_new cn_srp_roles.start_date%TYPE;
1518: l_srp_end_date_new cn_srp_roles.end_date%TYPE;
1519: l_start_date_new cn_srp_pay_groups.start_date%TYPE;
1520: l_end_date_new cn_srp_pay_groups.start_date%TYPE;

Line 1629: FROM cn_pay_groups_all

1625:
1626:
1627: SELECT name
1628: INTO l_pay_group_name_old
1629: FROM cn_pay_groups_all
1630: WHERE pay_group_id = l_pay_group_id_old;
1631:
1632: oldrec.employee_type := l_salesrep_type_old;
1633: oldrec.employee_number := l_emp_num_old;

Line 1669: FROM cn_pay_groups_all

1665: WHERE role_pay_group_id = p_role_pay_group_id;
1666:
1667: SELECT name
1668: INTO l_pay_group_name_new
1669: FROM cn_pay_groups_all
1670: WHERE pay_group_id = l_pay_group_id_new;
1671:
1672: SELECT count(*)
1673: INTO l_count_srp_pay_group