DBA Data[Home] [Help]

APPS.PSA_FA_MASS_ADDITIONS dependencies on FA_RX_FLEX_PKG

Line 40: p_where_clause := fa_rx_flex_pkg.flex_sql

36:
37: BEGIN
38: PRINT_HEADER_INFO (p_asset_book, p_capital_acct_from, p_capital_acct_to, p_cip_acct_from, p_cip_acct_to);
39:
40: p_where_clause := fa_rx_flex_pkg.flex_sql
41: (101, 'GL#', p_chart_of_accounts, 'CC', 'WHERE', 'ALL','BETWEEN', p_capital_acct_from, p_capital_acct_to);
42:
43: p_mass_add_query := 'SELECT mass_addition_id
44: FROM fa_mass_additions fma, gl_code_combinations cc

Line 78: p_where_clause := fa_rx_flex_pkg.flex_sql

74: END LOOP;
75:
76: CLOSE mass_add_cur;
77:
78: p_where_clause := fa_rx_flex_pkg.flex_sql
79: (101, 'GL#', p_chart_of_accounts,
80: 'CC', 'WHERE', 'ALL','BETWEEN', p_cip_acct_from, p_cip_acct_to);
81:
82: p_mass_add_cip_stmt := p_mass_add_query || ' AND ' || p_where_clause;