APPS.AP_IMPORT_VALIDATION_PKG dependencies on AP_DISTRIBUTION_SETS

Line 17072: AP_DISTRIBUTION_SETS.TOTAL_PERCENT_DISTRIBUTION%TYPE;

17068: l_dist_set_id_per_name NUMBER(15);
17069: l_inactive_date DATE;
17070: l_inactive_date_per_name DATE;
17071: l_total_percent_distribution
17072: AP_DISTRIBUTION_SETS.TOTAL_PERCENT_DISTRIBUTION%TYPE;
17073: l_dset_lines_tab AP_IMPORT_VALIDATION_PKG.dset_line_tab_type;
17074: l_expd_item_date ap_invoice_lines.expenditure_item_date%TYPE:= '';
17075: l_error_found VARCHAR2(1);
17076: i BINARY_INTEGER := 0;

Line 17161: FROM ap_distribution_sets

17157: BEGIN
17158: IF (p_invoice_lines_rec.distribution_set_id IS NOT NULL) THEN
17159: SELECT distribution_set_id , inactive_date, total_percent_distribution
17160: INTO l_dist_set_id, l_inactive_date, l_total_percent_distribution
17161: FROM ap_distribution_sets
17162: WHERE distribution_set_id = p_invoice_lines_rec.distribution_set_id;
17163: END IF;
17164:
17165: IF (p_invoice_lines_rec.distribution_set_name IS NOT NULL) THEN

Line 17169: FROM ap_distribution_sets

17165: IF (p_invoice_lines_rec.distribution_set_name IS NOT NULL) THEN
17166: SELECT distribution_set_id , inactive_date, total_percent_distribution
17167: INTO l_dist_set_id_per_name, l_inactive_date_per_name,
17168: l_total_percent_distribution
17169: FROM ap_distribution_sets
17170: WHERE distribution_set_name
17171: = p_invoice_lines_rec.distribution_set_name;
17172: END IF;
17173: