DBA Data[Home] [Help]

APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on FND_RESPONSIBILITY_VL

Line 810: FROM fnd_user_resp_groups_direct a,fnd_responsibility_vl b, fnd_user c

806:
807:
808: CURSOR user_check(cp_user_id IN fnd_user_resp_groups.user_id%TYPE) IS
809: SELECT 'X'
810: FROM fnd_user_resp_groups_direct a,fnd_responsibility_vl b, fnd_user c
811: WHERE a.user_id= cp_user_id
812: AND a.user_id = c.user_id
813: AND TRUNC(SYSDATE) BETWEEN TRUNC(c.start_date) AND TRUNC(NVL(c.end_date,SYSDATE))
814: AND a.responsibility_id= b.responsibility_id