APPS.JTF_RS_GROUP_MEMBERS_PVT dependencies on JTF_RS_RESOURCE_EXTNS

Line 116: FROM jtf_rs_resource_extns

112:
113:
114: CURSOR c_employee_person_id( l_resource_id IN NUMBER ) IS
115: SELECT source_id
116: FROM jtf_rs_resource_extns
117: WHERE resource_id = l_resource_id
118: AND category = 'EMPLOYEE';
119:
120: CURSOR c_is_active(l_group_id IN NUMBER, l_resource_id IN NUMBER) IS

Line 122: FROM JTF_RS_GROUPS_B a, JTF_RS_RESOURCE_EXTNS b

118: AND category = 'EMPLOYEE';
119:
120: CURSOR c_is_active(l_group_id IN NUMBER, l_resource_id IN NUMBER) IS
121: SELECT 'x'
122: FROM JTF_RS_GROUPS_B a, JTF_RS_RESOURCE_EXTNS b
123: WHERE a.group_id = l_group_id
124: AND b.resource_id = l_resource_id
125: AND trunc(sysdate) between a.start_date_active and nvl(a.end_date_active, sysdate)
126: AND trunc(sysdate) between b.start_date_active and nvl(b.end_date_active, sysdate);

Line 1829: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,

1825: P_INIT_MSG_LIST IN VARCHAR2,
1826: P_COMMIT IN VARCHAR2,
1827: P_OLD_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
1828: P_NEW_GROUP_ID IN JTF_RS_GROUP_MEMBERS.GROUP_ID%TYPE,
1829: P_RESOURCE_ID IN JTF_RS_RESOURCE_EXTNS.RESOURCE_ID%TYPE,
1830: P_OLD_START_DATE IN DATE,
1831: P_OLD_END_DATE IN DATE,
1832: P_NEW_START_DATE IN DATE,
1833: P_NEW_END_DATE IN DATE,