DBA Data[Home] [Help]

APPS.IGS_PR_PROUT_LGCY_PUB dependencies on IGS_FI_ENC_DFLT_EFT

Line 89: p_hold_effect_type OUT NOCOPY igs_fi_enc_dflt_eft.s_encmb_effect_type%TYPE,

85: p_person_id OUT NOCOPY igs_pe_person.person_id%TYPE,
86: p_prg_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,
87: p_prg_sequence_number OUT NOCOPY igs_ca_inst.sequence_number%TYPE,
88: p_outcome_sequence_number OUT NOCOPY igs_pr_stdnt_pr_ou_all.sequence_number%TYPE,
89: p_hold_effect_type OUT NOCOPY igs_fi_enc_dflt_eft.s_encmb_effect_type%TYPE,
90: p_org_start_dt OUT NOCOPY igs_pe_hz_parties.ou_start_dt%TYPE,
91: x_return_value OUT NOCOPY BOOLEAN
92: ) IS
93: --

Line 105: FROM igs_fi_enc_dflt_eft dft,

101: AND prg_ci_sequence_number = p_prg_sequence_number;
102: --
103: CURSOR cur_hold_effect_type IS
104: SELECT s_encmb_effect_type, s_progression_outcome_type
105: FROM igs_fi_enc_dflt_eft dft,
106: igs_pr_ou_type ou
107: WHERE dft.encumbrance_type = ou.encumbrance_type
108: AND ou.progression_outcome_type = p_lgcy_prout_rec.progression_outcome_type;
109: --