DBA Data[Home] [Help]

APPS.PSA_FA_INVOICE_DISTRIBUTIONS dependencies on FA_RX_FLEX_PKG

Line 44: p_where_clause := fa_rx_flex_pkg.flex_sql

40: BEGIN
41: l_from_gl_date := to_date(substr(p_from_gl_date,1,10),'YYYY/MM/DD');
42: l_to_gl_date := to_date(substr(p_to_gl_date,1,10) ,'YYYY/MM/DD');
43:
44: p_where_clause := fa_rx_flex_pkg.flex_sql
45: (101, 'GL#', p_chart_of_accounts, 'CC', 'WHERE', 'ALL','BETWEEN', p_from_account, p_to_account);
46:
47: p_inv_dist := 'SELECT invoice_id, distribution_line_number, invoice_distribution_id
48: FROM ap_invoice_distributions ap_inv_dist, gl_code_combinations cc