APPS.IGS_PR_GEN_004 dependencies on IGS_PR_OU_FND

Line 3762: FROM IGS_PR_OU_FND pfnd

3758: -- Start of new code added as per the FA110 PR Enh. Bug# 2658550.
3759: --
3760: CURSOR c_pfnd IS
3761: SELECT pfnd.fund_code
3762: FROM IGS_PR_OU_FND pfnd
3763: WHERE pfnd.progression_rule_cat = p_progression_rule_cat AND
3764: pfnd.pra_sequence_number = p_original_pra_sequence_number AND
3765: pfnd.pro_sequence_number = p_pro_sequence_number;
3766: --

Line 4461: FROM IGS_PR_OU_FND pfnd

4457: cp_progression_rule_cat IGS_PR_RU_APPL.progression_rule_cat%TYPE,
4458: cp_pra_sequence_number IGS_PR_RU_APPL.sequence_number%TYPE,
4459: cp_pro_sequence_number IGS_PR_RU_OU.sequence_number%TYPE) IS
4460: SELECT pfnd.ROWID
4461: FROM IGS_PR_OU_FND pfnd
4462: WHERE pfnd.progression_rule_cat = cp_progression_rule_cat AND
4463: pfnd.pra_sequence_number = cp_pra_sequence_number AND
4464: pfnd.pro_sequence_number = cp_pro_sequence_number
4465: FOR UPDATE NOWAIT;

Line 4634: IGS_PR_OU_FND_PKG.DELETE_ROW (v_pfnd_rec.ROWID);

4630: -- Delete from IGS_PR_OU_UNIT
4631: FOR v_pfnd_rec IN c_pfnd (v_pra_rec.progression_rule_cat,
4632: v_pra_rec.sequence_number,
4633: v_pro_rec.sequence_number) LOOP
4634: IGS_PR_OU_FND_PKG.DELETE_ROW (v_pfnd_rec.ROWID);
4635: END LOOP;
4636: --
4637: -- End of new code added as per the FA110 PR Enh. Bug# 2658550.
4638: --