APPS.IGS_FI_PRC_SP_FEES dependencies on IGS_PE_PERSON_BASE_V

Line 810: PROCEDURE validate_params( p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,

806: p_data => x_msg_data);
807: END IF;
808: END assess_fees_pvt;
809:
810: PROCEDURE validate_params( p_n_person_id IN igs_pe_person_base_v.person_id%TYPE,
811: p_n_person_grp_id IN igs_pe_persid_group_v.group_id%TYPE,
812: p_v_fee_period IN VARCHAR2,
813: p_v_test_run IN VARCHAR2,
814: p_d_gl_date IN VARCHAR2,

Line 839: CURSOR c_person_id (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS

835: -- are given as parameter
836: -------------------------------------------------------------------
837:
838: --Cursor for Checking the peson_id
839: CURSOR c_person_id (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
840: SELECT person_number
841: FROM IGS_PE_PERSON_BASE_V
842: WHERE person_id = cp_person_id;
843:

Line 841: FROM IGS_PE_PERSON_BASE_V

837:
838: --Cursor for Checking the peson_id
839: CURSOR c_person_id (cp_person_id igs_pe_person_base_v.person_id%TYPE) IS
840: SELECT person_number
841: FROM IGS_PE_PERSON_BASE_V
842: WHERE person_id = cp_person_id;
843:
844: --Cursor for checking Person Group
845: