eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.ZX_AR_FORMULA_MIG_PKG dependencies on AR_TAX_GROUP_CODES_ALL

Line 29: l_tax_condition_id ar_tax_group_codes_all.tax_condition_id%TYPE;

25: l_child_precedence zx_tax_relations_t.child_precedence%TYPE;
26: l_child_regime_code zx_tax_relations_t.child_regime_code %TYPE;
27: l_branch zx_tax_relations_t.branch_flag%TYPE;
28:
29: l_tax_condition_id ar_tax_group_codes_all.tax_condition_id%TYPE;
30: l_tax_exception_id ar_tax_group_codes_all.tax_exception_id%TYPE;
31: l_tax_group_id ar_tax_group_codes_all.tax_group_id%TYPE;
32:
33:

Line 30: l_tax_exception_id ar_tax_group_codes_all.tax_exception_id%TYPE;

26: l_child_regime_code zx_tax_relations_t.child_regime_code %TYPE;
27: l_branch zx_tax_relations_t.branch_flag%TYPE;
28:
29: l_tax_condition_id ar_tax_group_codes_all.tax_condition_id%TYPE;
30: l_tax_exception_id ar_tax_group_codes_all.tax_exception_id%TYPE;
31: l_tax_group_id ar_tax_group_codes_all.tax_group_id%TYPE;
32:
33:
34: l_formula_code zx_formula_b.formula_code%TYPE;

Line 31: l_tax_group_id ar_tax_group_codes_all.tax_group_id%TYPE;

27: l_branch zx_tax_relations_t.branch_flag%TYPE;
28:
29: l_tax_condition_id ar_tax_group_codes_all.tax_condition_id%TYPE;
30: l_tax_exception_id ar_tax_group_codes_all.tax_exception_id%TYPE;
31: l_tax_group_id ar_tax_group_codes_all.tax_group_id%TYPE;
32:
33:
34: l_formula_code zx_formula_b.formula_code%TYPE;
35:

Line 94: FROM zx_tax_relations_t tax_rel_upg, ar_tax_group_codes_all grp, zx_rates_b zx_rate,

90: grp.tax_exception_id,
91: grp.tax_group_id,
92: zx_rate.tax_regime_code,
93: zx_rate.tax
94: FROM zx_tax_relations_t tax_rel_upg, ar_tax_group_codes_all grp, zx_rates_b zx_rate,
95: zx_rates_b zx_par_rate -- 8726049
96: WHERE tax_rel_upg.tax_group_id NOT IN (SELECT tax_group_id
97: FROM zx_tax_relations_t
98: WHERE TRUNC(child_precedence) <> child_precedence )

Line 135: FROM zx_tax_relations_t tax_rel_upg, ar_tax_group_codes_all grp, zx_rates_b zx_rate,

131: grp.tax_exception_id,
132: grp.tax_group_id,
133: zx_rate.tax_regime_code,
134: zx_rate.tax
135: FROM zx_tax_relations_t tax_rel_upg, ar_tax_group_codes_all grp, zx_rates_b zx_rate,
136: zx_rates_b zx_par_rate -- 8726049
137: WHERE tax_rel_upg.tax_group_id IN (SELECT tax_group_id
138: FROM zx_tax_relations_t
139: WHERE child_precedence > TRUNC(child_precedence) )

Line 1050: p_tax_condition_id IN ar_tax_group_codes_all.tax_condition_id%TYPE,

1046: p_content_owner_id IN zx_rates_b.content_owner_id%TYPE, -- for zx_process_results
1047: p_condition_grp_cd IN fnd_lookups.lookup_code%TYPE,
1048: p_alphanumeric_result IN zx_process_results.alphanumeric_result%TYPE,
1049: p_condition_group_id IN zx_condition_groups_b.condition_group_id%TYPE,
1050: p_tax_condition_id IN ar_tax_group_codes_all.tax_condition_id%TYPE,
1051: p_tax_exception_id IN ar_tax_group_codes_all.tax_exception_id%TYPE,
1052: x_return_status OUT NOCOPY VARCHAR2 ) IS
1053:
1054: --l_tax_rule_id zx_rules_b.tax_rule_id%TYPE;

Line 1051: p_tax_exception_id IN ar_tax_group_codes_all.tax_exception_id%TYPE,

1047: p_condition_grp_cd IN fnd_lookups.lookup_code%TYPE,
1048: p_alphanumeric_result IN zx_process_results.alphanumeric_result%TYPE,
1049: p_condition_group_id IN zx_condition_groups_b.condition_group_id%TYPE,
1050: p_tax_condition_id IN ar_tax_group_codes_all.tax_condition_id%TYPE,
1051: p_tax_exception_id IN ar_tax_group_codes_all.tax_exception_id%TYPE,
1052: x_return_status OUT NOCOPY VARCHAR2 ) IS
1053:
1054: --l_tax_rule_id zx_rules_b.tax_rule_id%TYPE;
1055: l_tax_rule_code zx_rules_b.tax_rule_code%TYPE;