APPS.AP_IMPORT_VALIDATION_PKG dependencies on AP_AWT_GROUPS

Line 3329: FROM ap_awt_groups

3325:
3326: --validate awt_group_id
3327: SELECT group_id, inactive_date
3328: INTO l_awt_group_id, l_inactive_date
3329: FROM ap_awt_groups
3330: WHERE group_id = p_invoice_rec.awt_group_id;
3331:
3332: END IF;
3333:

Line 3338: FROM ap_awt_groups

3334: IF (p_invoice_rec.awt_group_name is NOT NULL) THEN
3335: --validate awt group name and retrieve awt group id
3336: SELECT group_id, inactive_date
3337: INTO l_awt_group_id_per_name, l_inactive_date_per_name
3338: FROM ap_awt_groups
3339: WHERE name = p_invoice_rec.awt_group_name;
3340: END IF;
3341:
3342: IF (l_awt_group_id is NOT NULL) AND

Line 3550: FROM ap_awt_groups

3546:
3547: --validate pay_awt_group_id
3548: SELECT group_id, inactive_date
3549: INTO l_pay_awt_group_id, l_inactive_date
3550: FROM ap_awt_groups
3551: WHERE group_id = p_invoice_rec.pay_awt_group_id;
3552:
3553: END IF;
3554:

Line 3559: FROM ap_awt_groups

3555: IF (p_invoice_rec.pay_awt_group_name is NOT NULL) THEN
3556: --validate pay awt group name and retrieve pay awt group id
3557: SELECT group_id, inactive_date
3558: INTO l_pay_awt_group_id_per_name, l_inactive_date_per_name
3559: FROM ap_awt_groups
3560: WHERE name = p_invoice_rec.pay_awt_group_name;
3561: END IF;
3562:
3563: IF (l_pay_awt_group_id is NOT NULL) AND

Line 18452: FROM ap_awt_groups

18448: IF p_invoice_lines_rec.awt_group_id is not null THEN
18449: --validate awt_group_id
18450: SELECT group_id, inactive_date
18451: INTO l_awt_group_id, l_inactive_date
18452: FROM ap_awt_groups
18453: WHERE group_id = p_invoice_lines_rec.awt_group_id;
18454: END IF;
18455:
18456: IF (p_invoice_lines_rec.awt_group_name is NOT NULL) THEN

Line 18460: FROM ap_awt_groups

18456: IF (p_invoice_lines_rec.awt_group_name is NOT NULL) THEN
18457: --validate awt group name and retrieve awt group id
18458: SELECT group_id, inactive_date
18459: INTO l_awt_group_id_per_name, l_inactive_date_per_name
18460: FROM ap_awt_groups
18461: WHERE name = p_invoice_lines_rec.awt_group_name;
18462: END IF;
18463:
18464: IF (l_awt_group_id is NOT NULL) AND

Line 18637: FROM ap_awt_groups

18633: IF p_invoice_lines_rec.pay_awt_group_id is not null THEN
18634: --validate pay_awt_group_id
18635: SELECT group_id, inactive_date
18636: INTO l_pay_awt_group_id, l_inactive_date
18637: FROM ap_awt_groups
18638: WHERE group_id = p_invoice_lines_rec.pay_awt_group_id;
18639: END IF;
18640:
18641: IF (p_invoice_lines_rec.pay_awt_group_name is NOT NULL) THEN

Line 18645: FROM ap_awt_groups

18641: IF (p_invoice_lines_rec.pay_awt_group_name is NOT NULL) THEN
18642: --validate pay awt group name and retrieve pay awt group id
18643: SELECT group_id, inactive_date
18644: INTO l_pay_awt_group_id_per_name, l_inactive_date_per_name
18645: FROM ap_awt_groups
18646: WHERE name = p_invoice_lines_rec.pay_awt_group_name;
18647: END IF;
18648:
18649: IF (l_pay_awt_group_id is NOT NULL) AND