APPS.IGS_PS_VALIDATE_LGCY_PKG dependencies on FND_USER

Line 640: sommukhe 12-JAN-2006 Bug#4926548, in the cursor user_check changed the table fnd_user_resp_groups to fnd_user_resp_groups_direct

636:
637: Known limitations,enhancements,remarks:
638: Change History (in reverse chronological order)
639: Who When What
640: sommukhe 12-JAN-2006 Bug#4926548, in the cursor user_check changed the table fnd_user_resp_groups to fnd_user_resp_groups_direct
641: modified the cursors c_anon_grd_method and c_cal_rel also introduced new cursors c_min_load_start_dt and cur_teach_load.
642: sarakshi 13-Apr-2004 Bug#3555871,added validation of teach calender association with load calender.Also removed the call of get_call_number .
643: sarakshi 21-oct-2003 Bug#3052452,used igs_ps_gen_003.enrollment_for_uoo_check in place of using a local cursor
644: smvk 24-Sep-2003 Bug # 3121311. Removed the validation to check unit contact person is of person type staff member.

Line 808: CURSOR user_check(cp_user_id IN fnd_user_resp_groups.user_id%TYPE) IS

804: AND no_assessment_ind='Y';
805: rec_unit_audit cur_unit_audit%ROWTYPE;
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

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