APPS.IGR_IMP_001 dependencies on IGR_IS_PERSON

Line 96: igr_is_person pe,

92: inq.attribute19,
93: inq.attribute20,
94: inq.source_promotion_id
95: FROM
96: igr_is_person pe,
97: igr_is_inquiry inq
98: WHERE
99: pe.inq_person_id = inq.inq_person_id AND
100: inq.inquiry_type_id = p_inquiry_type_id AND

Line 1002: UPDATE igr_is_person SET status = 'T' WHERE inq_person_id = inq_rec.inq_person_id;

998:
999: /* if all the validations are successful so far update the Status of
1000: Corresponding Self Service Records to Transferred (T) */
1001: UPDATE igr_is_inquiry SET status = 'T' WHERE inq_person_id = inq_rec.inq_person_id;
1002: UPDATE igr_is_person SET status = 'T' WHERE inq_person_id = inq_rec.inq_person_id;
1003:
1004: /* Now import the Child tables */
1005: -- kamohan 21-MAY-2002
1006: -- Bug 2378114 Add a row for Phone and Email separately