APPS.IGS_EN_GEN_004 dependencies on IGS_PE_USR_ARG

Line 553: l_person_type IGS_PE_USR_ARG.person_type%TYPE;

549: and Record Cutoff date alias value is less than Record Open date alias value for Institution setup , w.r.t. bug 2660310
550: **********************************************************************************************************************************************************/
551: BEGIN
552: DECLARE
553: l_person_type IGS_PE_USR_ARG.person_type%TYPE;
554: l_record_open_dt_alias IGS_EN_CAL_CONF.record_open_dt_alias%TYPE;
555: l_record_cutoff_dt_alias IGS_EN_CAL_CONF.record_cutoff_dt_alias%TYPE;
556: l_daiv_rec_found BOOLEAN;
557: l_rec_open_dt_pass BOOLEAN;

Line 563: CURSOR c_recdt_alias_per_lvl( cp_person_type IGS_PE_USR_ARG.person_type%TYPE ) IS

559: l_rec_cutt_off_dt IGS_CA_DA_INST_V.alias_val%TYPE;
560: l_effective_date DATE;
561:
562: --modified cursor for performance bug 3696424
563: CURSOR c_recdt_alias_per_lvl( cp_person_type IGS_PE_USR_ARG.person_type%TYPE ) IS
564: SELECT record_open_dt_alias,
565: record_cutoff_dt_alias
566: FROM IGS_PE_USR_ARG_ALL
567: WHERE person_type = cp_person_type;

Line 566: FROM IGS_PE_USR_ARG_ALL

562: --modified cursor for performance bug 3696424
563: CURSOR c_recdt_alias_per_lvl( cp_person_type IGS_PE_USR_ARG.person_type%TYPE ) IS
564: SELECT record_open_dt_alias,
565: record_cutoff_dt_alias
566: FROM IGS_PE_USR_ARG_ALL
567: WHERE person_type = cp_person_type;
568:
569: --Cursor is to get the all open date alias values for a calendar instance in ascending order.
570: CURSOR c_alias_val_op_dt(cp_cal_type IGS_CA_DA_INST_V.cal_type%TYPE,