DBA Data[Home] [Help]

APPS.IGS_FI_GEN_004 dependencies on IGS_FI_CONTROL

Line 411: l_v_manage_accounts igs_fi_control.manage_accounts%TYPE;

407: p_fee_cal_type igs_ca_inst.cal_type%TYPE ;
408: p_fee_ci_sequence_num igs_ca_inst.sequence_number%TYPE ;
409:
410: l_v_message_name fnd_new_messages.message_name%TYPE;
411: l_v_manage_accounts igs_fi_control.manage_accounts%TYPE;
412: l_n_waiver_amount NUMBER;
413:
414: BEGIN -- finp_prc_enr_fa_todo
415: -- Module to control processing fee assessments from entries in the student

Line 930: l_v_manage_accounts igs_fi_control.manage_accounts%TYPE;

926: l_dynamic_sql VARCHAR2(32767);
927: l_v_status VARCHAR2(10);
928:
929: l_v_message_name fnd_new_messages.message_name%TYPE;
930: l_v_manage_accounts igs_fi_control.manage_accounts%TYPE;
931:
932: l_v_person_number igs_fi_parties_v.person_number%TYPE := NULL;
933:
934: CURSOR cur_pers_grp(cp_n_pers_grp_id igs_pe_persid_group_all.group_id%TYPE) IS

Line 960: FROM igs_fi_control;

956:
957: CURSOR cur_fee_calc_mthd
958: IS
959: SELECT fee_calc_mthd_code
960: FROM igs_fi_control;
961: l_fee_calc_mthd_code igs_fi_control.fee_calc_mthd_code%TYPE;
962:
963: BEGIN
964: BEGIN

Line 961: l_fee_calc_mthd_code igs_fi_control.fee_calc_mthd_code%TYPE;

957: CURSOR cur_fee_calc_mthd
958: IS
959: SELECT fee_calc_mthd_code
960: FROM igs_fi_control;
961: l_fee_calc_mthd_code igs_fi_control.fee_calc_mthd_code%TYPE;
962:
963: BEGIN
964: BEGIN
965: l_org_id := NULL;

Line 1512: FROM igs_fi_control;

1508:
1509: CURSOR cur_fee_calc_mthd
1510: IS
1511: SELECT fee_calc_mthd_code
1512: FROM igs_fi_control;
1513: l_fee_calc_mthd_code igs_fi_control.fee_calc_mthd_code%TYPE;
1514:
1515: CURSOR cur_career (cp_course_cd IN igs_ps_ver.course_cd%type)
1516: IS

Line 1513: l_fee_calc_mthd_code igs_fi_control.fee_calc_mthd_code%TYPE;

1509: CURSOR cur_fee_calc_mthd
1510: IS
1511: SELECT fee_calc_mthd_code
1512: FROM igs_fi_control;
1513: l_fee_calc_mthd_code igs_fi_control.fee_calc_mthd_code%TYPE;
1514:
1515: CURSOR cur_career (cp_course_cd IN igs_ps_ver.course_cd%type)
1516: IS
1517: SELECT course_type