APPS.IGS_FI_PRC_WAIVERS dependencies on IGS_PE_PERSID_GROUP_V

Line 1212: CURSOR cur_chk_per_grp_id(cp_n_person_grp_id IGS_PE_PERSID_GROUP_V.group_id%TYPE)

1208: --
1209: --Change History:
1210: --Who When What
1211: -------------------------------------------------------------------
1212: CURSOR cur_chk_per_grp_id(cp_n_person_grp_id IGS_PE_PERSID_GROUP_V.group_id%TYPE)
1213: IS
1214: SELECT 'X'
1215: FROM igs_pe_persid_group_v
1216: WHERE group_id = cp_n_person_grp_id;

Line 1215: FROM igs_pe_persid_group_v

1211: -------------------------------------------------------------------
1212: CURSOR cur_chk_per_grp_id(cp_n_person_grp_id IGS_PE_PERSID_GROUP_V.group_id%TYPE)
1213: IS
1214: SELECT 'X'
1215: FROM igs_pe_persid_group_v
1216: WHERE group_id = cp_n_person_grp_id;
1217:
1218: CURSOR cur_chk_waiver_name(cp_v_fee_cal_type IGS_FI_WAIVER_PGMS.FEE_CAL_TYPE%TYPE,
1219: cp_n_fee_ci_seq_nbr IGS_FI_WAIVER_PGMS.FEE_CI_SEQUENCE_NUMBER%TYPE,

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

1471:
1472: l_c_alt_code_desc c_get_alt_code%ROWTYPE;
1473:
1474: --Cursor For Getting The Group Code For The Group Id
1475: CURSOR c_get_person_grp (c_group_id igs_pe_persid_group_v.group_id%TYPE) IS
1476: SELECT group_cd
1477: FROM igs_pe_persid_group_v
1478: WHERE group_id = c_group_id;
1479:

Line 1477: FROM igs_pe_persid_group_v

1473:
1474: --Cursor For Getting The Group Code For The Group Id
1475: CURSOR c_get_person_grp (c_group_id igs_pe_persid_group_v.group_id%TYPE) IS
1476: SELECT group_cd
1477: FROM igs_pe_persid_group_v
1478: WHERE group_id = c_group_id;
1479:
1480: l_c_get_person_grp c_get_person_grp%ROWTYPE;
1481:

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

1579: e_resource_busy EXCEPTION;
1580: PRAGMA EXCEPTION_INIT(e_resource_busy, -54);
1581:
1582: --Cursor For Getting The Group Code For The Group Id
1583: CURSOR c_get_person_grp (c_group_id igs_pe_persid_group_v.group_id%TYPE) IS
1584: SELECT group_cd
1585: FROM igs_pe_persid_group_v
1586: WHERE group_id = c_group_id;
1587: l_c_get_person_grp c_get_person_grp%ROWTYPE;

Line 1585: FROM igs_pe_persid_group_v

1581:
1582: --Cursor For Getting The Group Code For The Group Id
1583: CURSOR c_get_person_grp (c_group_id igs_pe_persid_group_v.group_id%TYPE) IS
1584: SELECT group_cd
1585: FROM igs_pe_persid_group_v
1586: WHERE group_id = c_group_id;
1587: l_c_get_person_grp c_get_person_grp%ROWTYPE;
1588:
1589: --Cursor For Getting The Alternate Code For The Fee Period.