DBA Data[Home] [Help]

APPS.AS_SALES_LEADS_PVT dependencies on JTF_RS_ROLE_RELATIONS

Line 1464: jtf_rs_role_relations rrel,

1460: Cursor C_Check_Assign_Salesforce (X_Assign_Id NUMBER) IS
1461: SELECT 'X'
1462: FROM per_all_people_f per,
1463: jtf_rs_resource_extns res,
1464: jtf_rs_role_relations rrel,
1465: jtf_rs_roles_b role
1466: WHERE TRUNC(SYSDATE) BETWEEN per.effective_start_date
1467: AND per.effective_end_date
1468: AND res.resource_id = rrel.role_resource_id

Line 4482: JTF_RS_ROLE_RELATIONS rrel,

4478: VARCHAR2)
4479: IS
4480: SELECT grp.group_id
4481: FROM JTF_RS_GROUP_MEMBERS mem,
4482: JTF_RS_ROLE_RELATIONS rrel,
4483: JTF_RS_ROLES_B role,
4484: JTF_RS_GROUP_USAGES u,
4485: JTF_RS_GROUPS_B grp
4486: WHERE mem.group_member_id = rrel.role_resource_id