APPS.JTF_RS_CONC_RES_PUB dependencies on JTF_RS_ROLES_B

Line 297: FROM jtf_rs_roles_b

293:
294: -- Added the below cursor to get the role type for a role id.
295: CURSOR c_get_role_type (l_role_id jtf_rs_roles_vl.role_id%TYPE) IS
296: SELECT role_type_code
297: FROM jtf_rs_roles_b
298: WHERE role_id = l_role_id;
299:
300: l_role_type_code jtf_rs_roles_b.role_type_code%TYPE;
301:

Line 300: l_role_type_code jtf_rs_roles_b.role_type_code%TYPE;

296: SELECT role_type_code
297: FROM jtf_rs_roles_b
298: WHERE role_id = l_role_id;
299:
300: l_role_type_code jtf_rs_roles_b.role_type_code%TYPE;
301:
302: CURSOR c_sales_credit_type_id (l_sales_credit_type oe_sales_credit_types.name%TYPE) IS
303: SELECT sales_credit_type_id
304: FROM oe_sales_credit_types

Line 1759: FROM jtf_rs_roles_b

1755:
1756: -- Added the below cursor to get the role type for a role id.
1757: CURSOR c_get_role_type (l_role_id jtf_rs_roles_vl.role_id%TYPE) IS
1758: SELECT role_type_code
1759: FROM jtf_rs_roles_b
1760: WHERE role_id = l_role_id;
1761:
1762: l_role_type_code jtf_rs_roles_b.role_type_code%TYPE;
1763:

Line 1762: l_role_type_code jtf_rs_roles_b.role_type_code%TYPE;

1758: SELECT role_type_code
1759: FROM jtf_rs_roles_b
1760: WHERE role_id = l_role_id;
1761:
1762: l_role_type_code jtf_rs_roles_b.role_type_code%TYPE;
1763:
1764: -- Added the below cursor to check the salesrep exists for the resource_id. If the salesrep does not esists
1765: -- we will not create the sales compensation roles.
1766: