APPS.JTF_RS_CONC_RES_PUB dependencies on JTF_RS_ROLES_B

Line 355: FROM jtf_rs_roles_b

351:
352: -- Added the below cursor to get the role type for a role id.
353: CURSOR c_get_role_type (l_role_id jtf_rs_roles_vl.role_id%TYPE) IS
354: SELECT role_type_code
355: FROM jtf_rs_roles_b
356: WHERE role_id = l_role_id;
357:
358: l_role_type_code jtf_rs_roles_b.role_type_code%TYPE;
359:

Line 358: l_role_type_code jtf_rs_roles_b.role_type_code%TYPE;

354: SELECT role_type_code
355: FROM jtf_rs_roles_b
356: WHERE role_id = l_role_id;
357:
358: l_role_type_code jtf_rs_roles_b.role_type_code%TYPE;
359:
360: CURSOR c_sales_credit_type_id (l_sales_credit_type oe_sales_credit_types.name%TYPE) IS
361: SELECT sales_credit_type_id
362: FROM oe_sales_credit_types

Line 1857: FROM jtf_rs_roles_b

1853:
1854: -- Added the below cursor to get the role type for a role id.
1855: CURSOR c_get_role_type (l_role_id jtf_rs_roles_vl.role_id%TYPE) IS
1856: SELECT role_type_code
1857: FROM jtf_rs_roles_b
1858: WHERE role_id = l_role_id;
1859:
1860: l_role_type_code jtf_rs_roles_b.role_type_code%TYPE;
1861:

Line 1860: l_role_type_code jtf_rs_roles_b.role_type_code%TYPE;

1856: SELECT role_type_code
1857: FROM jtf_rs_roles_b
1858: WHERE role_id = l_role_id;
1859:
1860: l_role_type_code jtf_rs_roles_b.role_type_code%TYPE;
1861:
1862: -- Added the below cursor to check the salesrep exists for the resource_id. If the salesrep does not esists
1863: -- we will not create the sales compensation roles.
1864: