APPS.AS_ACCESS_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 863: jtf_rs_resource_extns res

859:
860: Cursor C_Check_Assign_Person (X_person_id NUMBER) IS
861: SELECT 'X'
862: FROM per_all_people_f per,
863: jtf_rs_resource_extns res
864: WHERE per.person_id = X_person_id
865: AND TRUNC(SYSDATE) BETWEEN per.effective_start_date
866: AND per.effective_end_date
867: AND res.category = 'EMPLOYEE'

Line 927: FROM jtf_rs_resource_extns res,

923:
924: Cursor C_Check_Assign_Salesforce (X_Assign_Id NUMBER) IS
925:
926: SELECT 'X'
927: FROM jtf_rs_resource_extns res,
928: jtf_rs_role_relations rrel,
929: jtf_rs_roles_b role
930: WHERE sysdate between res.start_date_active and nvl(res.end_date_active,sysdate)
931: AND sysdate between rrel.start_date_active and nvl(rrel.end_date_active,sysdate)

Line 1693: from jtf_rs_resource_extns

1689: and nvl(salesforce_role_code, 'X') = nvl(p_sales_team_rec.salesforce_role_code, 'X');
1690:
1691: cursor lc_resource_type (pc_resource_id number) is
1692: select source_id
1693: from jtf_rs_resource_extns
1694: where resource_id = pc_resource_id
1695: and category = 'PARTY';
1696:
1697: l_module CONSTANT VARCHAR2(255) := 'as.plsql.acspv.Create_SalesTeam';