APPS.IGS_FI_PRC_SP_FEES dependencies on IGS_PE_PERSID_GROUP_V

Line 811: p_n_person_grp_id IN igs_pe_persid_group_v.group_id%TYPE,

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,
815: p_v_fee_cal_type OUT NOCOPY igs_ca_inst.cal_type%TYPE,

Line 846: CURSOR c_person_grp_id(cp_person_grp_id igs_pe_persid_group_v.group_id%TYPE) IS

842: WHERE person_id = cp_person_id;
843:
844: --Cursor for checking Person Group
845:
846: CURSOR c_person_grp_id(cp_person_grp_id igs_pe_persid_group_v.group_id%TYPE) IS
847: SELECT 'X'
848: FROM igs_pe_persid_group_v
849: WHERE group_id = cp_person_grp_id
850: AND closed_ind = 'N';

Line 848: FROM igs_pe_persid_group_v

844: --Cursor for checking Person Group
845:
846: CURSOR c_person_grp_id(cp_person_grp_id igs_pe_persid_group_v.group_id%TYPE) IS
847: SELECT 'X'
848: FROM igs_pe_persid_group_v
849: WHERE group_id = cp_person_grp_id
850: AND closed_ind = 'N';
851:
852: l_b_parameter_val_status BOOLEAN;

Line 1023: CURSOR c_get_person_grp (c_group_id igs_pe_persid_group_v.group_id%TYPE) IS

1019: WHERE cal_type = cp_v_cal_type
1020: AND sequence_number = cp_n_sequence_number;
1021: l_c_alt_code_desc c_get_alt_code_desc%ROWTYPE;
1022: --Cursor For Getting The Group Code For The Group Id
1023: CURSOR c_get_person_grp (c_group_id igs_pe_persid_group_v.group_id%TYPE) IS
1024: SELECT group_cd
1025: FROM igs_pe_persid_group_v
1026: WHERE group_id = c_group_id;
1027: l_c_get_person_grp c_get_person_grp%ROWTYPE;

Line 1025: FROM igs_pe_persid_group_v

1021: l_c_alt_code_desc c_get_alt_code_desc%ROWTYPE;
1022: --Cursor For Getting The Group Code For The Group Id
1023: CURSOR c_get_person_grp (c_group_id igs_pe_persid_group_v.group_id%TYPE) IS
1024: SELECT group_cd
1025: FROM igs_pe_persid_group_v
1026: WHERE group_id = c_group_id;
1027: l_c_get_person_grp c_get_person_grp%ROWTYPE;
1028: l_v_alt_code_msg VARCHAR2(500) DEFAULT NULL;
1029: