DBA Data[Home] [Help]

APPS.QP_MULTI_CURRENCY_PVT dependencies on QP_CURRENCY_DETAILS

Line 296: TYPE currency_header_id_tab IS TABLE OF qp_currency_details.currency_header_id%TYPE INDEX BY BINARY_INTEGER;

292: TYPE operand_value_tab IS TABLE OF qp_npreq_ldets_tmp.operand_value%TYPE INDEX BY BINARY_INTEGER;
293: TYPE operand_calc_code_tab IS TABLE OF qp_npreq_ldets_tmp.operand_calculation_code%TYPE INDEX BY BINARY_INTEGER;
294: TYPE base_currency_code_tab IS TABLE OF qp_npreq_ldets_tmp.base_currency_code%TYPE INDEX BY BINARY_INTEGER;
295: TYPE pricing_effective_date_tab IS TABLE OF qp_npreq_ldets_tmp.pricing_effective_date%TYPE INDEX BY BINARY_INTEGER;
296: TYPE currency_header_id_tab IS TABLE OF qp_currency_details.currency_header_id%TYPE INDEX BY BINARY_INTEGER;
297: TYPE to_currency_code_tab IS TABLE OF qp_currency_details.to_currency_code%TYPE INDEX BY BINARY_INTEGER;
298: TYPE fixed_value_tab IS TABLE OF qp_currency_details.fixed_value%TYPE INDEX BY BINARY_INTEGER;
299: TYPE price_formula_id_tab IS TABLE OF qp_currency_details.price_formula_id%TYPE INDEX BY BINARY_INTEGER;
300: TYPE conversion_type_tab IS TABLE OF qp_currency_details.conversion_type%TYPE INDEX BY BINARY_INTEGER;

Line 297: TYPE to_currency_code_tab IS TABLE OF qp_currency_details.to_currency_code%TYPE INDEX BY BINARY_INTEGER;

293: TYPE operand_calc_code_tab IS TABLE OF qp_npreq_ldets_tmp.operand_calculation_code%TYPE INDEX BY BINARY_INTEGER;
294: TYPE base_currency_code_tab IS TABLE OF qp_npreq_ldets_tmp.base_currency_code%TYPE INDEX BY BINARY_INTEGER;
295: TYPE pricing_effective_date_tab IS TABLE OF qp_npreq_ldets_tmp.pricing_effective_date%TYPE INDEX BY BINARY_INTEGER;
296: TYPE currency_header_id_tab IS TABLE OF qp_currency_details.currency_header_id%TYPE INDEX BY BINARY_INTEGER;
297: TYPE to_currency_code_tab IS TABLE OF qp_currency_details.to_currency_code%TYPE INDEX BY BINARY_INTEGER;
298: TYPE fixed_value_tab IS TABLE OF qp_currency_details.fixed_value%TYPE INDEX BY BINARY_INTEGER;
299: TYPE price_formula_id_tab IS TABLE OF qp_currency_details.price_formula_id%TYPE INDEX BY BINARY_INTEGER;
300: TYPE conversion_type_tab IS TABLE OF qp_currency_details.conversion_type%TYPE INDEX BY BINARY_INTEGER;
301: TYPE conversion_date_type_tab IS TABLE OF qp_currency_details.conversion_date_type%TYPE INDEX BY BINARY_INTEGER;

Line 298: TYPE fixed_value_tab IS TABLE OF qp_currency_details.fixed_value%TYPE INDEX BY BINARY_INTEGER;

294: TYPE base_currency_code_tab IS TABLE OF qp_npreq_ldets_tmp.base_currency_code%TYPE INDEX BY BINARY_INTEGER;
295: TYPE pricing_effective_date_tab IS TABLE OF qp_npreq_ldets_tmp.pricing_effective_date%TYPE INDEX BY BINARY_INTEGER;
296: TYPE currency_header_id_tab IS TABLE OF qp_currency_details.currency_header_id%TYPE INDEX BY BINARY_INTEGER;
297: TYPE to_currency_code_tab IS TABLE OF qp_currency_details.to_currency_code%TYPE INDEX BY BINARY_INTEGER;
298: TYPE fixed_value_tab IS TABLE OF qp_currency_details.fixed_value%TYPE INDEX BY BINARY_INTEGER;
299: TYPE price_formula_id_tab IS TABLE OF qp_currency_details.price_formula_id%TYPE INDEX BY BINARY_INTEGER;
300: TYPE conversion_type_tab IS TABLE OF qp_currency_details.conversion_type%TYPE INDEX BY BINARY_INTEGER;
301: TYPE conversion_date_type_tab IS TABLE OF qp_currency_details.conversion_date_type%TYPE INDEX BY BINARY_INTEGER;
302: TYPE conversion_date_tab IS TABLE OF qp_currency_details.conversion_date%TYPE INDEX BY BINARY_INTEGER;

Line 299: TYPE price_formula_id_tab IS TABLE OF qp_currency_details.price_formula_id%TYPE INDEX BY BINARY_INTEGER;

295: TYPE pricing_effective_date_tab IS TABLE OF qp_npreq_ldets_tmp.pricing_effective_date%TYPE INDEX BY BINARY_INTEGER;
296: TYPE currency_header_id_tab IS TABLE OF qp_currency_details.currency_header_id%TYPE INDEX BY BINARY_INTEGER;
297: TYPE to_currency_code_tab IS TABLE OF qp_currency_details.to_currency_code%TYPE INDEX BY BINARY_INTEGER;
298: TYPE fixed_value_tab IS TABLE OF qp_currency_details.fixed_value%TYPE INDEX BY BINARY_INTEGER;
299: TYPE price_formula_id_tab IS TABLE OF qp_currency_details.price_formula_id%TYPE INDEX BY BINARY_INTEGER;
300: TYPE conversion_type_tab IS TABLE OF qp_currency_details.conversion_type%TYPE INDEX BY BINARY_INTEGER;
301: TYPE conversion_date_type_tab IS TABLE OF qp_currency_details.conversion_date_type%TYPE INDEX BY BINARY_INTEGER;
302: TYPE conversion_date_tab IS TABLE OF qp_currency_details.conversion_date%TYPE INDEX BY BINARY_INTEGER;
303: TYPE rounding_factor_tab IS TABLE OF qp_currency_details.rounding_factor%TYPE INDEX BY BINARY_INTEGER;

Line 300: TYPE conversion_type_tab IS TABLE OF qp_currency_details.conversion_type%TYPE INDEX BY BINARY_INTEGER;

296: TYPE currency_header_id_tab IS TABLE OF qp_currency_details.currency_header_id%TYPE INDEX BY BINARY_INTEGER;
297: TYPE to_currency_code_tab IS TABLE OF qp_currency_details.to_currency_code%TYPE INDEX BY BINARY_INTEGER;
298: TYPE fixed_value_tab IS TABLE OF qp_currency_details.fixed_value%TYPE INDEX BY BINARY_INTEGER;
299: TYPE price_formula_id_tab IS TABLE OF qp_currency_details.price_formula_id%TYPE INDEX BY BINARY_INTEGER;
300: TYPE conversion_type_tab IS TABLE OF qp_currency_details.conversion_type%TYPE INDEX BY BINARY_INTEGER;
301: TYPE conversion_date_type_tab IS TABLE OF qp_currency_details.conversion_date_type%TYPE INDEX BY BINARY_INTEGER;
302: TYPE conversion_date_tab IS TABLE OF qp_currency_details.conversion_date%TYPE INDEX BY BINARY_INTEGER;
303: TYPE rounding_factor_tab IS TABLE OF qp_currency_details.rounding_factor%TYPE INDEX BY BINARY_INTEGER;
304: TYPE markup_operator_tab IS TABLE OF qp_currency_details.markup_operator%TYPE INDEX BY BINARY_INTEGER;

Line 301: TYPE conversion_date_type_tab IS TABLE OF qp_currency_details.conversion_date_type%TYPE INDEX BY BINARY_INTEGER;

297: TYPE to_currency_code_tab IS TABLE OF qp_currency_details.to_currency_code%TYPE INDEX BY BINARY_INTEGER;
298: TYPE fixed_value_tab IS TABLE OF qp_currency_details.fixed_value%TYPE INDEX BY BINARY_INTEGER;
299: TYPE price_formula_id_tab IS TABLE OF qp_currency_details.price_formula_id%TYPE INDEX BY BINARY_INTEGER;
300: TYPE conversion_type_tab IS TABLE OF qp_currency_details.conversion_type%TYPE INDEX BY BINARY_INTEGER;
301: TYPE conversion_date_type_tab IS TABLE OF qp_currency_details.conversion_date_type%TYPE INDEX BY BINARY_INTEGER;
302: TYPE conversion_date_tab IS TABLE OF qp_currency_details.conversion_date%TYPE INDEX BY BINARY_INTEGER;
303: TYPE rounding_factor_tab IS TABLE OF qp_currency_details.rounding_factor%TYPE INDEX BY BINARY_INTEGER;
304: TYPE markup_operator_tab IS TABLE OF qp_currency_details.markup_operator%TYPE INDEX BY BINARY_INTEGER;
305: TYPE markup_value_tab IS TABLE OF qp_currency_details.markup_value%TYPE INDEX BY BINARY_INTEGER;

Line 302: TYPE conversion_date_tab IS TABLE OF qp_currency_details.conversion_date%TYPE INDEX BY BINARY_INTEGER;

298: TYPE fixed_value_tab IS TABLE OF qp_currency_details.fixed_value%TYPE INDEX BY BINARY_INTEGER;
299: TYPE price_formula_id_tab IS TABLE OF qp_currency_details.price_formula_id%TYPE INDEX BY BINARY_INTEGER;
300: TYPE conversion_type_tab IS TABLE OF qp_currency_details.conversion_type%TYPE INDEX BY BINARY_INTEGER;
301: TYPE conversion_date_type_tab IS TABLE OF qp_currency_details.conversion_date_type%TYPE INDEX BY BINARY_INTEGER;
302: TYPE conversion_date_tab IS TABLE OF qp_currency_details.conversion_date%TYPE INDEX BY BINARY_INTEGER;
303: TYPE rounding_factor_tab IS TABLE OF qp_currency_details.rounding_factor%TYPE INDEX BY BINARY_INTEGER;
304: TYPE markup_operator_tab IS TABLE OF qp_currency_details.markup_operator%TYPE INDEX BY BINARY_INTEGER;
305: TYPE markup_value_tab IS TABLE OF qp_currency_details.markup_value%TYPE INDEX BY BINARY_INTEGER;
306: TYPE markup_formula_id_tab IS TABLE OF qp_currency_details.markup_formula_id%TYPE INDEX BY BINARY_INTEGER;

Line 303: TYPE rounding_factor_tab IS TABLE OF qp_currency_details.rounding_factor%TYPE INDEX BY BINARY_INTEGER;

299: TYPE price_formula_id_tab IS TABLE OF qp_currency_details.price_formula_id%TYPE INDEX BY BINARY_INTEGER;
300: TYPE conversion_type_tab IS TABLE OF qp_currency_details.conversion_type%TYPE INDEX BY BINARY_INTEGER;
301: TYPE conversion_date_type_tab IS TABLE OF qp_currency_details.conversion_date_type%TYPE INDEX BY BINARY_INTEGER;
302: TYPE conversion_date_tab IS TABLE OF qp_currency_details.conversion_date%TYPE INDEX BY BINARY_INTEGER;
303: TYPE rounding_factor_tab IS TABLE OF qp_currency_details.rounding_factor%TYPE INDEX BY BINARY_INTEGER;
304: TYPE markup_operator_tab IS TABLE OF qp_currency_details.markup_operator%TYPE INDEX BY BINARY_INTEGER;
305: TYPE markup_value_tab IS TABLE OF qp_currency_details.markup_value%TYPE INDEX BY BINARY_INTEGER;
306: TYPE markup_formula_id_tab IS TABLE OF qp_currency_details.markup_formula_id%TYPE INDEX BY BINARY_INTEGER;
307: TYPE error_message_tab IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;

Line 304: TYPE markup_operator_tab IS TABLE OF qp_currency_details.markup_operator%TYPE INDEX BY BINARY_INTEGER;

300: TYPE conversion_type_tab IS TABLE OF qp_currency_details.conversion_type%TYPE INDEX BY BINARY_INTEGER;
301: TYPE conversion_date_type_tab IS TABLE OF qp_currency_details.conversion_date_type%TYPE INDEX BY BINARY_INTEGER;
302: TYPE conversion_date_tab IS TABLE OF qp_currency_details.conversion_date%TYPE INDEX BY BINARY_INTEGER;
303: TYPE rounding_factor_tab IS TABLE OF qp_currency_details.rounding_factor%TYPE INDEX BY BINARY_INTEGER;
304: TYPE markup_operator_tab IS TABLE OF qp_currency_details.markup_operator%TYPE INDEX BY BINARY_INTEGER;
305: TYPE markup_value_tab IS TABLE OF qp_currency_details.markup_value%TYPE INDEX BY BINARY_INTEGER;
306: TYPE markup_formula_id_tab IS TABLE OF qp_currency_details.markup_formula_id%TYPE INDEX BY BINARY_INTEGER;
307: TYPE error_message_tab IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
308: TYPE status_code_tab IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;

Line 305: TYPE markup_value_tab IS TABLE OF qp_currency_details.markup_value%TYPE INDEX BY BINARY_INTEGER;

301: TYPE conversion_date_type_tab IS TABLE OF qp_currency_details.conversion_date_type%TYPE INDEX BY BINARY_INTEGER;
302: TYPE conversion_date_tab IS TABLE OF qp_currency_details.conversion_date%TYPE INDEX BY BINARY_INTEGER;
303: TYPE rounding_factor_tab IS TABLE OF qp_currency_details.rounding_factor%TYPE INDEX BY BINARY_INTEGER;
304: TYPE markup_operator_tab IS TABLE OF qp_currency_details.markup_operator%TYPE INDEX BY BINARY_INTEGER;
305: TYPE markup_value_tab IS TABLE OF qp_currency_details.markup_value%TYPE INDEX BY BINARY_INTEGER;
306: TYPE markup_formula_id_tab IS TABLE OF qp_currency_details.markup_formula_id%TYPE INDEX BY BINARY_INTEGER;
307: TYPE error_message_tab IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
308: TYPE status_code_tab IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
309: TYPE lines_status_code_tab IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;

Line 306: TYPE markup_formula_id_tab IS TABLE OF qp_currency_details.markup_formula_id%TYPE INDEX BY BINARY_INTEGER;

302: TYPE conversion_date_tab IS TABLE OF qp_currency_details.conversion_date%TYPE INDEX BY BINARY_INTEGER;
303: TYPE rounding_factor_tab IS TABLE OF qp_currency_details.rounding_factor%TYPE INDEX BY BINARY_INTEGER;
304: TYPE markup_operator_tab IS TABLE OF qp_currency_details.markup_operator%TYPE INDEX BY BINARY_INTEGER;
305: TYPE markup_value_tab IS TABLE OF qp_currency_details.markup_value%TYPE INDEX BY BINARY_INTEGER;
306: TYPE markup_formula_id_tab IS TABLE OF qp_currency_details.markup_formula_id%TYPE INDEX BY BINARY_INTEGER;
307: TYPE error_message_tab IS TABLE OF VARCHAR2(2000) INDEX BY BINARY_INTEGER;
308: TYPE status_code_tab IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
309: TYPE lines_status_code_tab IS TABLE OF VARCHAR2(30) INDEX BY BINARY_INTEGER;
310:

Line 364: qp_currency_details a,

360: ,a.markup_operator
361: ,a.markup_value
362: ,a.markup_formula_id
363: FROM
364: qp_currency_details a,
365: qp_npreq_ldets_tmp b
366: --j_qp_npreq_ldets_tmp b
367: WHERE
368: a.currency_header_id = b.currency_header_id