APPS.IGS_PR_GEN_004 dependencies on IGS_PR_OU_AWD

Line 3752: FROM IGS_PR_OU_AWD poa

3748: pous.pro_sequence_number = p_pro_sequence_number;
3749:
3750: CURSOR c_poa IS
3751: SELECT poa.award_cd
3752: FROM IGS_PR_OU_AWD poa
3753: WHERE poa.progression_rule_cat = p_progression_rule_cat AND
3754: poa.pra_sequence_number = p_original_pra_sequence_number AND
3755: poa.pro_sequence_number = p_pro_sequence_number;
3756:

Line 4429: FROM IGS_PR_OU_AWD poa

4425: cp_progression_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
4426: cp_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE,
4427: cp_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE) IS
4428: SELECT poa.ROWID
4429: FROM IGS_PR_OU_AWD poa
4430: WHERE poa.progression_rule_cat = cp_progression_rule_cat AND
4431: poa.pra_sequence_number = cp_pra_sequence_number AND
4432: poa.pro_sequence_number = cp_pro_sequence_number
4433: FOR UPDATE NOWAIT;

Line 4610: -- Delete from IGS_PR_OU_AWD

4606: v_pous_rec.ROWID
4607: );
4608: END LOOP;
4609:
4610: -- Delete from IGS_PR_OU_AWD
4611: FOR v_poa_rec IN c_poa (
4612: v_pra_rec.progression_rule_cat,
4613: v_pra_rec.sequence_number,
4614: v_pro_rec.sequence_number) LOOP

Line 4615: IGS_PR_OU_AWD_PKG.DELETE_ROW(v_poa_rec.ROWID);

4611: FOR v_poa_rec IN c_poa (
4612: v_pra_rec.progression_rule_cat,
4613: v_pra_rec.sequence_number,
4614: v_pro_rec.sequence_number) LOOP
4615: IGS_PR_OU_AWD_PKG.DELETE_ROW(v_poa_rec.ROWID);
4616: END LOOP;
4617:
4618: -- Delete from IGS_PR_OU_UNIT
4619: FOR v_popu_rec IN c_popu (