APPS.IGS_PS_GEN_001 dependencies on IGS_PS_USEC_X_GRPMEM

Line 2209: FROM igs_ps_usec_x_grpmem grpmem, igs_ps_usec_x_grp grp

2205: --9
2206: CURSOR usec_x_grpmem (cp_uoo_id NUMBER) IS
2207: SELECT grpmem.*, grp.usec_x_listed_group_name , grp.location_inheritance,
2208: grp.max_enr_group,max_ovr_group
2209: FROM igs_ps_usec_x_grpmem grpmem, igs_ps_usec_x_grp grp
2210: WHERE grp.usec_x_listed_group_id = grpmem.usec_x_listed_group_id
2211: AND grpmem.uoo_id = cp_uoo_id;
2212:
2213: -- 10

Line 3149: CURSOR cur_usec_x_grpmem_new (cp_uoo_id igs_ps_usec_x_grpmem.uoo_id%TYPE) IS

3145: -- removed unit section cross listed units and unit section cross list unit sections
3146: -- added the unit section cross list group and unit section group member.
3147: -- Unit SECTION cross list GROUP
3148: DECLARE
3149: CURSOR cur_usec_x_grpmem_new (cp_uoo_id igs_ps_usec_x_grpmem.uoo_id%TYPE) IS
3150: SELECT 'X'
3151: FROM igs_ps_usec_x_grpmem
3152: WHERE uoo_id = cp_uoo_id
3153: AND ROWNUM = 1;

Line 3151: FROM igs_ps_usec_x_grpmem

3147: -- Unit SECTION cross list GROUP
3148: DECLARE
3149: CURSOR cur_usec_x_grpmem_new (cp_uoo_id igs_ps_usec_x_grpmem.uoo_id%TYPE) IS
3150: SELECT 'X'
3151: FROM igs_ps_usec_x_grpmem
3152: WHERE uoo_id = cp_uoo_id
3153: AND ROWNUM = 1;
3154: l_cur_usec_x_grpmem_new cur_usec_x_grpmem_new%ROWTYPE;
3155:

Line 3195: igs_ps_usec_x_grpmem_pkg.insert_row (

3191: OPEN cur_usec_x_grpmem_new(p_new_uoo_id);
3192: FETCH cur_usec_x_grpmem_new INTO l_cur_usec_x_grpmem_new;
3193: IF cur_usec_x_grpmem_new%NOTFOUND THEN
3194: -- Rollover of unit section in cross listed group
3195: igs_ps_usec_x_grpmem_pkg.insert_row (
3196: x_rowid => lv_GrpMemrowid,
3197: x_usec_x_listed_group_mem_id => lnusec_x_listed_group_mem_id,
3198: x_usec_x_listed_group_id => lnUsec_X_Grp_Id,
3199: x_uoo_id => p_new_uoo_id,