DBA Data[Home] [Help]

APPS.PSA_FA_INVOICE_DISTRIBUTIONS dependencies on AP_INVOICE_DISTRIBUTIONS_ALL

Line 28: l_invoice_id ap_invoice_distributions_all.invoice_id%type;

24: p_where_clause VARCHAR2(3000);
25: p_inv_dist VARCHAR2(4000);
26: p_prev_inv NUMBER := 0;
27:
28: l_invoice_id ap_invoice_distributions_all.invoice_id%type;
29: l_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%type;
30: l_dist_line_num ap_invoice_distributions_all.distribution_line_number%type;
31:
32: TYPE var_cur IS REF CURSOR;

Line 29: l_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%type;

25: p_inv_dist VARCHAR2(4000);
26: p_prev_inv NUMBER := 0;
27:
28: l_invoice_id ap_invoice_distributions_all.invoice_id%type;
29: l_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%type;
30: l_dist_line_num ap_invoice_distributions_all.distribution_line_number%type;
31:
32: TYPE var_cur IS REF CURSOR;
33: inv_dist_cur VAR_CUR;

Line 30: l_dist_line_num ap_invoice_distributions_all.distribution_line_number%type;

26: p_prev_inv NUMBER := 0;
27:
28: l_invoice_id ap_invoice_distributions_all.invoice_id%type;
29: l_inv_dist_id ap_invoice_distributions_all.invoice_distribution_id%type;
30: l_dist_line_num ap_invoice_distributions_all.distribution_line_number%type;
31:
32: TYPE var_cur IS REF CURSOR;
33: inv_dist_cur VAR_CUR;
34: -- ========================= FND LOG ===========================