APPS.IGS_FI_PRC_FEE_ASS dependencies on IGS_PS_UNIT_TYPE_LVL

Line 655: FUNCTION finpl_get_uptl(p_n_unit_type_id IN igs_ps_unit_type_lvl.unit_type_id%TYPE) RETURN VARCHAR2 AS

651: END IF;
652:
653: END finpl_get_unit_type_level;
654:
655: FUNCTION finpl_get_uptl(p_n_unit_type_id IN igs_ps_unit_type_lvl.unit_type_id%TYPE) RETURN VARCHAR2 AS
656:
657: /*************************************************************
658: Created By : Priya Athipatla
659: Date Created By : 02-Sep-2005

Line 669: CURSOR cur_uptl(cp_n_unit_type_id igs_ps_unit_type_lvl.unit_type_id%TYPE) IS

665: Who When What
666: ***************************************************************/
667:
668: -- Cursor to fetch the Level Code for the Unit Program Type Level Id.
669: CURSOR cur_uptl(cp_n_unit_type_id igs_ps_unit_type_lvl.unit_type_id%TYPE) IS
670: SELECT level_code
671: FROM igs_ps_unit_type_lvl
672: WHERE unit_type_id = cp_n_unit_type_id;
673:

Line 671: FROM igs_ps_unit_type_lvl

667:
668: -- Cursor to fetch the Level Code for the Unit Program Type Level Id.
669: CURSOR cur_uptl(cp_n_unit_type_id igs_ps_unit_type_lvl.unit_type_id%TYPE) IS
670: SELECT level_code
671: FROM igs_ps_unit_type_lvl
672: WHERE unit_type_id = cp_n_unit_type_id;
673:
674: l_v_level_code igs_ps_unit_type_lvl.level_code%TYPE;
675:

Line 674: l_v_level_code igs_ps_unit_type_lvl.level_code%TYPE;

670: SELECT level_code
671: FROM igs_ps_unit_type_lvl
672: WHERE unit_type_id = cp_n_unit_type_id;
673:
674: l_v_level_code igs_ps_unit_type_lvl.level_code%TYPE;
675:
676: BEGIN
677:
678: OPEN cur_uptl(p_n_unit_type_id);

Line 1562: l_v_level_code igs_ps_unit_type_lvl.level_code%TYPE;

1558: v_derived_unit_mode igs_fi_fee_as_rate.unit_mode%TYPE;
1559: v_derived_unit_cd igs_fi_fee_as_rate.unit_cd%TYPE;
1560: v_derived_unit_version_num igs_fi_fee_as_rate.unit_version_number%TYPE;
1561: v_derived_unit_level igs_fi_fee_as_rate.unit_level%TYPE;
1562: l_v_level_code igs_ps_unit_type_lvl.level_code%TYPE;
1563:
1564: l_v_inst_course_cd igs_fi_fai_dtls.course_cd%TYPE;
1565: l_v_inst_unit_att_status igs_fi_fai_dtls.unit_attempt_status%TYPE;
1566: l_v_inst_location_cd igs_fi_fai_dtls.location_cd%TYPE;

Line 2509: l_v_level_code igs_ps_unit_type_lvl.level_code%TYPE;

2505:
2506: l_c_ftfarv1 c_ftfarv1%ROWTYPE;
2507: l_b_cursor BOOLEAN;
2508: l_v_party_number hz_parties.party_number%TYPE := NULL;
2509: l_v_level_code igs_ps_unit_type_lvl.level_code%TYPE;
2510:
2511: BEGIN
2512: log_to_fnd( p_v_module => 'finpl_find_far',
2513: p_v_string => 'Entered finpl_find_far. Parameters are: ' ||

Line 2925: l_v_level_code igs_ps_unit_type_lvl.level_code%TYPE;

2921: l_n_rate_factor igs_fi_fee_as_items.chg_elements%TYPE;
2922: l_b_flag BOOLEAN;
2923: l_b_first_rate_match BOOLEAN;
2924: l_v_ret_level igs_fi_f_typ_ca_inst_all.retention_level_code%TYPE;
2925: l_v_level_code igs_ps_unit_type_lvl.level_code%TYPE;
2926:
2927: BEGIN
2928:
2929: l_n_record_found := 0;