DBA Data[Home] [Help]

APPS.ZX_TDS_TAX_ROUNDING_PKG dependencies on ZX_LINES_DET_FACTORS

Line 2185: FROM ZX_LINES_DET_FACTORS

2181: provnl_tax_determination_date,
2182: adjusted_doc_date,
2183: trx_line_date,
2184: trx_date) tax_determine_date
2185: FROM ZX_LINES_DET_FACTORS
2186: WHERE application_id = p_event_class_rec.application_id
2187: AND entity_code = p_event_class_rec.entity_code
2188: AND event_class_code = p_event_class_rec.event_class_code
2189: AND trx_id = p_event_class_rec.trx_id

Line 7508: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;

7504: IS
7505:
7506: l_rounding_rule_code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE;
7507: l_tax_rounding_rule_code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE;
7508: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;
7509: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7510: l_trx_min_acct_unit ZX_LINES_DET_FACTORS.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7511: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
7512: l_trx_precision ZX_LINES_DET_FACTORS.PRECISION%TYPE;

Line 7510: l_trx_min_acct_unit ZX_LINES_DET_FACTORS.MINIMUM_ACCOUNTABLE_UNIT%TYPE;

7506: l_rounding_rule_code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE;
7507: l_tax_rounding_rule_code ZX_TAXES_B.ROUNDING_RULE_CODE%TYPE;
7508: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;
7509: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7510: l_trx_min_acct_unit ZX_LINES_DET_FACTORS.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7511: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
7512: l_trx_precision ZX_LINES_DET_FACTORS.PRECISION%TYPE;
7513: l_event_class_rec ZX_API_PUB.EVENT_CLASS_REC_TYPE;
7514: l_unrounded_tax_amt ZX_LINES.UNROUNDED_TAX_AMT%TYPE;

Line 7512: l_trx_precision ZX_LINES_DET_FACTORS.PRECISION%TYPE;

7508: l_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE;
7509: l_tax_min_acct_unit ZX_TAXES_B.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7510: l_trx_min_acct_unit ZX_LINES_DET_FACTORS.MINIMUM_ACCOUNTABLE_UNIT%TYPE;
7511: l_tax_precision ZX_TAXES_B.TAX_PRECISION%TYPE;
7512: l_trx_precision ZX_LINES_DET_FACTORS.PRECISION%TYPE;
7513: l_event_class_rec ZX_API_PUB.EVENT_CLASS_REC_TYPE;
7514: l_unrounded_tax_amt ZX_LINES.UNROUNDED_TAX_AMT%TYPE;
7515: l_rounding_level_code ZX_PARTY_TAX_PROFILE.Rounding_Level_Code%TYPE;
7516: l_rnd_lvl_party_tax_prof_id ZX_LINES.ROUNDING_LVL_PARTY_TAX_PROF_ID%TYPE;

Line 7538: -- to get trx currency info from zx_lines_det_factors

7534: EVENT_CLASS_CODE = c_event_class_code;
7535:
7536: -- bug#6798349
7537: -- add trx_currency_code, precision, minimum_accountable_unit
7538: -- to get trx currency info from zx_lines_det_factors
7539:
7540: CURSOR get_rnd_tx_prof_id_csr
7541: (c_application_id ZX_LINES.APPLICATION_ID%TYPE,
7542: c_entity_code ZX_LINES.ENTITY_CODE%TYPE,

Line 7557: FROM ZX_LINES_DET_FACTORS

7553: rdng_bill_from_pty_tx_p_st_id,
7554: trx_currency_code,
7555: precision,
7556: minimum_accountable_unit
7557: FROM ZX_LINES_DET_FACTORS
7558: WHERE APPLICATION_ID = c_application_id AND
7559: ENTITY_CODE = c_entity_code AND
7560: EVENT_CLASS_CODE = c_event_class_code AND
7561: TRX_ID = c_trx_id;

Line 7574: (c_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE)

7570: WHERE TAX_ID = c_tax_id;
7571:
7572: -- bug#6798349
7573: CURSOR get_precision_mau_csr
7574: (c_trx_currency_code ZX_LINES_DET_FACTORS.TRX_CURRENCY_CODE%TYPE)
7575: IS
7576: SELECT minimum_accountable_unit,
7577: precision
7578: FROM FND_CURRENCIES