343: INTO
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
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
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
360: AND
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
360: AND
361: jtf_rs_resource_extns.category ='EMPLOYEE')
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
360: AND
361: jtf_rs_resource_extns.category ='EMPLOYEE')
362: OR
363: (jtf_rs_resource_extns.source_id = fnd_user.customer_id
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
360: AND
361: jtf_rs_resource_extns.category ='EMPLOYEE')
362: OR
363: (jtf_rs_resource_extns.source_id = fnd_user.customer_id
364: AND
365: jtf_rs_resource_extns.category ='PARTY'));
359: (jtf_rs_resource_extns.source_id = fnd_user.employee_id
360: AND
361: jtf_rs_resource_extns.category ='EMPLOYEE')
362: OR
363: (jtf_rs_resource_extns.source_id = fnd_user.customer_id
364: AND
365: jtf_rs_resource_extns.category ='PARTY'));
366:
367:
361: jtf_rs_resource_extns.category ='EMPLOYEE')
362: OR
363: (jtf_rs_resource_extns.source_id = fnd_user.customer_id
364: AND
365: jtf_rs_resource_extns.category ='PARTY'));
366:
367:
368: -- set return value to TRUE if something is found.
369: if (m_temp = m_user_id) THEN
1722: SELECT DISTINCT
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'
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
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' )
1735: OR (jtf_rs_resource_extns.source_id = fnd_user.customer_id
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' )
1735: OR (jtf_rs_resource_extns.source_id = fnd_user.customer_id
1736: AND jtf_rs_resource_extns.category = 'PARTY' )
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' )
1735: OR (jtf_rs_resource_extns.source_id = fnd_user.customer_id
1736: AND jtf_rs_resource_extns.category = 'PARTY' )
1737: );
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' )
1735: OR (jtf_rs_resource_extns.source_id = fnd_user.customer_id
1736: AND jtf_rs_resource_extns.category = 'PARTY' )
1737: );
1738:
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' )
1735: OR (jtf_rs_resource_extns.source_id = fnd_user.customer_id
1736: AND jtf_rs_resource_extns.category = 'PARTY' )
1737: );
1738:
1739: BEGIN
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' )
1735: OR (jtf_rs_resource_extns.source_id = fnd_user.customer_id
1736: AND jtf_rs_resource_extns.category = 'PARTY' )
1737: );
1738:
1739: BEGIN
1740: