APPS.CS_KB_WF_PKG dependencies on JTF_RS_GROUP_MEMBERS

Line 348: jtf_rs_group_members

344: m_temp
345: FROM
346: fnd_user,
347: jtf_rs_resource_extns,
348: jtf_rs_group_members
349: WHERE
350: jtf_rs_group_members.resource_id=jtf_rs_resource_extns.resource_id
351: AND
352: fnd_user.user_id=m_user_id

Line 350: jtf_rs_group_members.resource_id=jtf_rs_resource_extns.resource_id

346: fnd_user,
347: jtf_rs_resource_extns,
348: jtf_rs_group_members
349: WHERE
350: jtf_rs_group_members.resource_id=jtf_rs_resource_extns.resource_id
351: AND
352: fnd_user.user_id=m_user_id
353: AND
354: jtf_rs_group_members.group_id=m_group_id

Line 354: jtf_rs_group_members.group_id=m_group_id

350: jtf_rs_group_members.resource_id=jtf_rs_resource_extns.resource_id
351: AND
352: fnd_user.user_id=m_user_id
353: AND
354: jtf_rs_group_members.group_id=m_group_id
355: AND jtf_rs_group_members.DELETE_FLAG <>'Y'
356: AND jtf_rs_resource_extns.START_DATE_ACTIVE <= sysdate
357: AND NVL(jtf_rs_resource_extns.END_DATE_ACTIVE, sysdate) >= sysdate
358: AND (

Line 355: AND jtf_rs_group_members.DELETE_FLAG <>'Y'

351: AND
352: fnd_user.user_id=m_user_id
353: AND
354: jtf_rs_group_members.group_id=m_group_id
355: AND jtf_rs_group_members.DELETE_FLAG <>'Y'
356: AND jtf_rs_resource_extns.START_DATE_ACTIVE <= sysdate
357: AND NVL(jtf_rs_resource_extns.END_DATE_ACTIVE, sysdate) >= sysdate
358: AND (
359: (jtf_rs_resource_extns.source_id = fnd_user.employee_id

Line 1727: jtf_rs_group_members

1723: fnd_user.user_name,
1724: fnd_user.user_id
1725: FROM fnd_user,
1726: jtf_rs_resource_extns,
1727: jtf_rs_group_members
1728: WHERE jtf_rs_group_members.resource_id=jtf_rs_resource_extns.resource_id
1729: AND jtf_rs_group_members.group_id = v_group_id
1730: AND jtf_rs_group_members.DELETE_FLAG <> 'Y'
1731: AND jtf_rs_resource_extns.START_DATE_ACTIVE <= sysdate

Line 1728: WHERE jtf_rs_group_members.resource_id=jtf_rs_resource_extns.resource_id

1724: fnd_user.user_id
1725: FROM fnd_user,
1726: jtf_rs_resource_extns,
1727: jtf_rs_group_members
1728: WHERE jtf_rs_group_members.resource_id=jtf_rs_resource_extns.resource_id
1729: AND jtf_rs_group_members.group_id = v_group_id
1730: AND jtf_rs_group_members.DELETE_FLAG <> 'Y'
1731: AND jtf_rs_resource_extns.START_DATE_ACTIVE <= sysdate
1732: AND NVL(jtf_rs_resource_extns.END_DATE_ACTIVE, sysdate) >= sysdate

Line 1729: AND jtf_rs_group_members.group_id = v_group_id

1725: FROM fnd_user,
1726: jtf_rs_resource_extns,
1727: jtf_rs_group_members
1728: WHERE jtf_rs_group_members.resource_id=jtf_rs_resource_extns.resource_id
1729: AND jtf_rs_group_members.group_id = v_group_id
1730: AND jtf_rs_group_members.DELETE_FLAG <> 'Y'
1731: AND jtf_rs_resource_extns.START_DATE_ACTIVE <= sysdate
1732: AND NVL(jtf_rs_resource_extns.END_DATE_ACTIVE, sysdate) >= sysdate
1733: AND( ( jtf_rs_resource_extns.source_id = fnd_user.employee_id

Line 1730: AND jtf_rs_group_members.DELETE_FLAG <> 'Y'

1726: jtf_rs_resource_extns,
1727: jtf_rs_group_members
1728: WHERE jtf_rs_group_members.resource_id=jtf_rs_resource_extns.resource_id
1729: AND jtf_rs_group_members.group_id = v_group_id
1730: AND jtf_rs_group_members.DELETE_FLAG <> 'Y'
1731: AND jtf_rs_resource_extns.START_DATE_ACTIVE <= sysdate
1732: AND NVL(jtf_rs_resource_extns.END_DATE_ACTIVE, sysdate) >= sysdate
1733: AND( ( jtf_rs_resource_extns.source_id = fnd_user.employee_id
1734: AND jtf_rs_resource_extns.category = 'EMPLOYEE' )