APPS.IGS_PS_USEC_SCHEDULE dependencies on IGS_PS_USEC_X_GRP_V

Line 577: FROM igs_ps_usec_x_grp_v A,

573:
574: -- Get the Cross Listed Group Name of the uoo_id
575: CURSOR usec_x_grp_name ( l_uoo_id igs_ps_unit_ofr_opt.uoo_id%TYPE ) IS
576: SELECT A.usec_x_listed_group_name
577: FROM igs_ps_usec_x_grp_v A,
578: igs_ps_usec_x_grpmem_v B
579: WHERE A.usec_x_listed_group_id = B.usec_x_listed_group_id
580: AND B.uoo_id = l_uoo_id
581: AND B.parent = 'Y';