APPS.IGS_FI_GEN_008 dependencies on IGS_FI_PP_STD_ATTRS

Line 50: FROM igs_fi_pp_std_attrs

46: ***********************************************************************************************/
47: CURSOR cur_plan_details( cp_n_person_id NUMBER ) IS
48: SELECT student_plan_id,
49: payment_plan_name
50: FROM igs_fi_pp_std_attrs
51: WHERE person_id = p_n_person_id
52: AND plan_status_code = 'ACTIVE';
53: rec_plan_details cur_plan_details%ROWTYPE;
54:

Line 109: l_n_act_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE;

105: Known limitations,enhancements,remarks:
106: Change History
107: Who When What
108: ***********************************************************************************************/
109: l_n_act_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE;
110: l_v_act_plan_name igs_fi_pp_std_attrs.payment_plan_name%TYPE;
111:
112: BEGIN
113:

Line 110: l_v_act_plan_name igs_fi_pp_std_attrs.payment_plan_name%TYPE;

106: Change History
107: Who When What
108: ***********************************************************************************************/
109: l_n_act_plan_id igs_fi_pp_std_attrs.student_plan_id%TYPE;
110: l_v_act_plan_name igs_fi_pp_std_attrs.payment_plan_name%TYPE;
111:
112: BEGIN
113:
114: get_plan_details ( p_n_person_id, l_n_act_plan_id, l_v_act_plan_name );