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 97: FROM zx_tax_relations_t tax_rel_upg, ar_tax_group_codes_all grp, zx_rates_b zx_rate

93: grp.tax_exception_id ,
94: grp.tax_group_id ,
95: zx_rate.tax_regime_code ,
96: zx_rate.tax
97: FROM zx_tax_relations_t tax_rel_upg, ar_tax_group_codes_all grp, zx_rates_b zx_rate
98: WHERE tax_rel_upg.tax_group_id NOT IN (SELECT tax_group_id
99: FROM zx_tax_relations_t
100: WHERE TRUNC(child_precedence) <> child_precedence )
101: AND grp.tax_group_id = tax_rel_upg.tax_group_id

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

125: grp.tax_exception_id ,
126: grp.tax_group_id ,
127: zx_rate.tax_regime_code ,
128: zx_rate.tax
129: FROM zx_tax_relations_t tax_rel_upg, ar_tax_group_codes_all grp, zx_rates_b zx_rate
130: WHERE tax_rel_upg.tax_group_id IN (SELECT tax_group_id
131: FROM zx_tax_relations_t
132: WHERE child_precedence > TRUNC(child_precedence) )
133: AND grp.tax_group_id = tax_rel_upg.tax_group_id

Line 1014: p_tax_condition_id IN ar_tax_group_codes_all.tax_condition_id%TYPE,

1010: p_content_owner_id IN zx_rates_b.content_owner_id%TYPE, -- for zx_process_results
1011: p_condition_grp_cd IN fnd_lookups.lookup_code%TYPE ,
1012: p_alphanumeric_result IN zx_process_results.alphanumeric_result%TYPE,
1013: p_condition_group_id IN zx_condition_groups_b.condition_group_id%TYPE,
1014: p_tax_condition_id IN ar_tax_group_codes_all.tax_condition_id%TYPE,
1015: p_tax_exception_id IN ar_tax_group_codes_all.tax_exception_id%TYPE,
1016: x_return_status OUT NOCOPY VARCHAR2 ) IS
1017:
1018: --l_tax_rule_id zx_rules_b.tax_rule_id%TYPE;

Line 1015: p_tax_exception_id IN ar_tax_group_codes_all.tax_exception_id%TYPE,

1011: p_condition_grp_cd IN fnd_lookups.lookup_code%TYPE ,
1012: p_alphanumeric_result IN zx_process_results.alphanumeric_result%TYPE,
1013: p_condition_group_id IN zx_condition_groups_b.condition_group_id%TYPE,
1014: p_tax_condition_id IN ar_tax_group_codes_all.tax_condition_id%TYPE,
1015: p_tax_exception_id IN ar_tax_group_codes_all.tax_exception_id%TYPE,
1016: x_return_status OUT NOCOPY VARCHAR2 ) IS
1017:
1018: --l_tax_rule_id zx_rules_b.tax_rule_id%TYPE;
1019: l_tax_rule_code zx_rules_b.tax_rule_code%TYPE;