APPS.CN_SRP_PAYGROUP_PUB dependencies on CN_ROLE_PAY_GROUPS

Line 60: from cn_role_pay_groups

56: BEGIN
57: -- get start_date, end_date org_id and pay_group_id from role_pay_groups
58: select org_id, pay_group_id, start_date, end_date
59: into l_org_id, l_pay_group_id, l_role_pg_start_date, l_role_pg_end_date
60: from cn_role_pay_groups
61: where role_pay_group_id = p_role_pay_group_id;
62:
63: -- get srp role assignment start and end dates
64: select start_date, end_date, salesrep_id

Line 676: l_role_pay_group_id cn_role_pay_groups.role_pay_group_id%TYPE;

672: l_org_id cn_srp_pay_groups.org_id%TYPE;
673: l_null_date CONSTANT DATE := to_date('31-12-9999','DD-MM-YYYY');
674: l_ovn_old NUMBER;
675: l_count NUMBER;
676: l_role_pay_group_id cn_role_pay_groups.role_pay_group_id%TYPE;
677: l_status VARCHAR2(1);
678:
679: --
680: --Declaration for user hooks

Line 1324: from cn_role_pay_groups_all

1320:
1321: -- begin API
1322: select pay_group_id, start_date, end_date, org_id
1323: into l_pay_group_id, l_pg_start_date, l_pg_end_date, l_org_id
1324: from cn_role_pay_groups_all
1325: where role_pay_group_id = p_role_pay_group_id;
1326:
1327: -- validate org ID
1328: mo_global.validate_orgid_pub_api

Line 1530: ( Select 1 from cn_srp_roles sr, cn_role_pay_groups rp

1526: from cn_srp_pay_groups sp
1527: where salesrep_id = l_salesrep_id_old
1528: AND role_pay_group_id = p_role_pay_group_id
1529: AND NOT EXISTS
1530: ( Select 1 from cn_srp_roles sr, cn_role_pay_groups rp
1531: Where salesrep_id = l_salesrep_id_old
1532: AND role_pay_group_id = p_role_pay_group_id
1533: AND sr.role_id = rp.role_id
1534: AND sr.org_id = rp.org_id

Line 1560: FROM cn_role_pay_groups_all

1556:
1557: -- begin API
1558: SELECT org_id
1559: INTO l_org_id
1560: FROM cn_role_pay_groups_all
1561: WHERE role_pay_group_id = p_role_pay_group_id;
1562:
1563: -- validate org ID
1564: mo_global.validate_orgid_pub_api

Line 1657: FROM cn_role_pay_groups_all

1653: AND org_id = l_org_id;
1654:
1655: SELECT pay_group_id, start_date, end_date
1656: INTO l_pay_group_id_new, l_pp_start_date_new, l_pp_end_date_new
1657: FROM cn_role_pay_groups_all
1658: WHERE role_pay_group_id = p_role_pay_group_id;
1659:
1660: SELECT name
1661: INTO l_pay_group_name_new