APPS.AP_IMPORT_VALIDATION_PKG dependencies on AP_AWT_GROUPS

Line 3526: FROM ap_awt_groups

3522:
3523: --validate awt_group_id
3524: SELECT group_id, inactive_date
3525: INTO l_awt_group_id, l_inactive_date
3526: FROM ap_awt_groups
3527: WHERE group_id = p_invoice_rec.awt_group_id;
3528:
3529: END IF;
3530:

Line 3535: FROM ap_awt_groups

3531: IF (p_invoice_rec.awt_group_name is NOT NULL) THEN
3532: --validate awt group name and retrieve awt group id
3533: SELECT group_id, inactive_date
3534: INTO l_awt_group_id_per_name, l_inactive_date_per_name
3535: FROM ap_awt_groups
3536: WHERE name = p_invoice_rec.awt_group_name;
3537: END IF;
3538:
3539: IF (l_awt_group_id is NOT NULL) AND

Line 3747: FROM ap_awt_groups

3743:
3744: --validate pay_awt_group_id
3745: SELECT group_id, inactive_date
3746: INTO l_pay_awt_group_id, l_inactive_date
3747: FROM ap_awt_groups
3748: WHERE group_id = p_invoice_rec.pay_awt_group_id;
3749:
3750: END IF;
3751:

Line 3756: FROM ap_awt_groups

3752: IF (p_invoice_rec.pay_awt_group_name is NOT NULL) THEN
3753: --validate pay awt group name and retrieve pay awt group id
3754: SELECT group_id, inactive_date
3755: INTO l_pay_awt_group_id_per_name, l_inactive_date_per_name
3756: FROM ap_awt_groups
3757: WHERE name = p_invoice_rec.pay_awt_group_name;
3758: END IF;
3759:
3760: IF (l_pay_awt_group_id is NOT NULL) AND

Line 20150: FROM ap_awt_groups

20146: IF p_invoice_lines_rec.awt_group_id is not null THEN
20147: --validate awt_group_id
20148: SELECT group_id, inactive_date
20149: INTO l_awt_group_id, l_inactive_date
20150: FROM ap_awt_groups
20151: WHERE group_id = p_invoice_lines_rec.awt_group_id;
20152: END IF;
20153:
20154: IF (p_invoice_lines_rec.awt_group_name is NOT NULL) THEN

Line 20158: FROM ap_awt_groups

20154: IF (p_invoice_lines_rec.awt_group_name is NOT NULL) THEN
20155: --validate awt group name and retrieve awt group id
20156: SELECT group_id, inactive_date
20157: INTO l_awt_group_id_per_name, l_inactive_date_per_name
20158: FROM ap_awt_groups
20159: WHERE name = p_invoice_lines_rec.awt_group_name;
20160: END IF;
20161:
20162: IF (l_awt_group_id is NOT NULL) AND

Line 20350: FROM ap_awt_groups

20346: IF p_invoice_lines_rec.pay_awt_group_id is not null THEN
20347: --validate pay_awt_group_id
20348: SELECT group_id, inactive_date
20349: INTO l_pay_awt_group_id, l_inactive_date
20350: FROM ap_awt_groups
20351: WHERE group_id = p_invoice_lines_rec.pay_awt_group_id;
20352: END IF;
20353:
20354: IF (p_invoice_lines_rec.pay_awt_group_name is NOT NULL) THEN

Line 20358: FROM ap_awt_groups

20354: IF (p_invoice_lines_rec.pay_awt_group_name is NOT NULL) THEN
20355: --validate pay awt group name and retrieve pay awt group id
20356: SELECT group_id, inactive_date
20357: INTO l_pay_awt_group_id_per_name, l_inactive_date_per_name
20358: FROM ap_awt_groups
20359: WHERE name = p_invoice_lines_rec.pay_awt_group_name;
20360: END IF;
20361:
20362: IF (l_pay_awt_group_id is NOT NULL) AND