37: l_match_flag := NULL;
38: l_awt_group_id := NULL;
39: /* Getting the AWT group id based on the tax treatment status */
40: IF (cur_igi_cis_verify_headers_rec.tax_treatment_status = 'net') THEN
41: l_awt_group_id := fnd_profile.VALUE('IGI_CIS2007_NET_WTH_GROUP');
42: ELSIF (cur_igi_cis_verify_headers_rec.tax_treatment_status = 'gross') THEN
43: l_awt_group_id := fnd_profile.VALUE('IGI_CIS2007_GROSS_WTH_GROUP');
44: ELSIF (cur_igi_cis_verify_headers_rec.tax_treatment_status =
45: 'unmatched') THEN
39: /* Getting the AWT group id based on the tax treatment status */
40: IF (cur_igi_cis_verify_headers_rec.tax_treatment_status = 'net') THEN
41: l_awt_group_id := fnd_profile.VALUE('IGI_CIS2007_NET_WTH_GROUP');
42: ELSIF (cur_igi_cis_verify_headers_rec.tax_treatment_status = 'gross') THEN
43: l_awt_group_id := fnd_profile.VALUE('IGI_CIS2007_GROSS_WTH_GROUP');
44: ELSIF (cur_igi_cis_verify_headers_rec.tax_treatment_status =
45: 'unmatched') THEN
46: l_awt_group_id := fnd_profile.VALUE('IGI_CIS2007_UNMATCHED_WTH_GROUP');
47: END IF;
42: ELSIF (cur_igi_cis_verify_headers_rec.tax_treatment_status = 'gross') THEN
43: l_awt_group_id := fnd_profile.VALUE('IGI_CIS2007_GROSS_WTH_GROUP');
44: ELSIF (cur_igi_cis_verify_headers_rec.tax_treatment_status =
45: 'unmatched') THEN
46: l_awt_group_id := fnd_profile.VALUE('IGI_CIS2007_UNMATCHED_WTH_GROUP');
47: END IF;
48: IF (l_awt_group_id IS NOT NULL) THEN
49: /* AWT group id - Active / Inactive validation */
50: SELECT g.group_id