APPS.IGS_HE_IMPORT_DATA dependencies on IGS_PE_PERS_DISABLTY

Line 546: FROM igs_pe_pers_disablty dis

542: -- smaddali modified this cursor to check that end_date is null and
543: -- start date could be null or not equal to sysdate, bug 2730129
544: CURSOR c_pe_dis IS
545: SELECT dis.rowid,dis.*
546: FROM igs_pe_pers_disablty dis
547: WHERE person_id = p_person_id AND
548: disability_type = l_oss_disability AND
549: end_date IS NULL
550: ORDER BY start_date DESC ;

Line 557: FROM igs_pe_pers_disablty dis

553: -- Get all the disability records for the person to be closed
554: -- smaddali modified this cursor to exclude current disability type , bug 2730129
555: CURSOR c_other_dis IS
556: SELECT dis.*
557: FROM igs_pe_pers_disablty dis
558: WHERE person_id = p_person_id
559: AND disability_type <> l_oss_disability
560: AND start_date IS NOT NULL
561: ORDER BY dis.disability_type DESC ;

Line 567: FROM igs_pe_pers_disablty dis

563: -- smaddali added this cursor for bug 2730129
564: -- check if there are any disability records of the passed type which are starting on sysdate
565: CURSOR c_pe_dis_sysdate IS
566: SELECT dis.*
567: FROM igs_pe_pers_disablty dis
568: WHERE person_id = p_person_id AND
569: disability_type = l_oss_disability AND
570: Trunc(start_date) = Trunc(SYSDATE)
571: ORDER BY start_date DESC ;

Line 760: IGS_PE_PERS_DISABLTY_PKG.UPDATE_ROW (

756: FETCH c_pe_dis_sysdate INTO c_pe_dis_sysdate_rec;
757: IF c_pe_dis_sysdate%NOTFOUND THEN
758: CLOSE c_pe_dis_sysdate;
759: BEGIN
760: IGS_PE_PERS_DISABLTY_PKG.UPDATE_ROW (
761: X_ROWID => c_pe_dis_rec.rowid,
762: X_IGS_PE_PERS_DISABLTY_ID => c_pe_dis_rec.igs_pe_pers_disablty_id,
763: x_PERSON_ID => c_pe_dis_rec.person_id,
764: x_DISABILITY_TYPE => c_pe_dis_rec.disability_type,

Line 762: X_IGS_PE_PERS_DISABLTY_ID => c_pe_dis_rec.igs_pe_pers_disablty_id,

758: CLOSE c_pe_dis_sysdate;
759: BEGIN
760: IGS_PE_PERS_DISABLTY_PKG.UPDATE_ROW (
761: X_ROWID => c_pe_dis_rec.rowid,
762: X_IGS_PE_PERS_DISABLTY_ID => c_pe_dis_rec.igs_pe_pers_disablty_id,
763: x_PERSON_ID => c_pe_dis_rec.person_id,
764: x_DISABILITY_TYPE => c_pe_dis_rec.disability_type,
765: x_CONTACT_IND => c_pe_dis_rec.contact_ind ,
766: x_SPECIAL_ALLOW_CD => c_pe_dis_rec.special_allow_cd,