APPS.IGS_FI_PRC_WAIVERS dependencies on IGS_PE_PERSID_GROUP

Line 1189: p_n_person_grp_id IN igs_pe_persid_group.group_id%TYPE,

1185: END IF;
1186: END log_to_fnd;
1187:
1188: PROCEDURE validate_params( p_n_person_id IN hz_parties.party_id%TYPE,
1189: p_n_person_grp_id IN igs_pe_persid_group.group_id%TYPE,
1190: p_v_fee_cal IN VARCHAR2,
1191: p_v_waiver_name IN IGS_FI_WAIVER_PGMS.WAIVER_NAME%TYPE,
1192: p_v_fee_type IN IGS_FI_WAIVER_PGMS.TARGET_FEE_TYPE%TYPE,
1193: p_d_gl_date IN VARCHAR2,

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 1447: p_n_person_grp_id IN igs_pe_persid_group.group_id%TYPE,

1443:
1444: END log_result;
1445:
1446: PROCEDURE log_in_parameters(p_n_person_id IN hz_parties.party_id%TYPE,
1447: p_n_person_grp_id IN igs_pe_persid_group.group_id%TYPE,
1448: p_v_fee_cal IN VARCHAR2,
1449: p_v_waiver_name IN IGS_FI_WAIVER_PGMS.WAIVER_NAME%TYPE,
1450: p_v_fee_type IN IGS_FI_WAIVER_PGMS.TARGET_FEE_TYPE%TYPE,
1451: p_d_gl_date IN VARCHAR2) IS

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 1531: p_person_grp_id IN igs_pe_persid_group.group_id%TYPE,

1527:
1528: PROCEDURE process_waivers( errbuf OUT NOCOPY VARCHAR2,
1529: retcode OUT NOCOPY NUMBER,
1530: p_person_id IN hz_parties.party_id%TYPE,
1531: p_person_grp_id IN igs_pe_persid_group.group_id%TYPE,
1532: p_fee_cal IN VARCHAR2,
1533: p_waiver_name IN IGS_FI_WAIVER_PGMS.WAIVER_NAME%TYPE,
1534: p_fee_type IN IGS_FI_WAIVER_PGMS.TARGET_FEE_TYPE%TYPE,
1535: p_gl_date IN VARCHAR2 ) IS

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.