14:
15: l_tax zx_rates_b.tax%TYPE;
16: l_tax_regime_code zx_rates_b.tax_regime_code%TYPE;
17:
18: l_content_owner_id zx_tax_relations_t.content_owner_id%TYPE;
19: l_group_id zx_tax_relations_t.tax_group_id%TYPE;
20: l_tax_group_code zx_tax_relations_t.tax_group_code%TYPE;
21: l_parent_tax_code zx_tax_relations_t.parent_tax_code %TYPE;
22: l_parent_precedence zx_tax_relations_t.parent_precedence%TYPE;
15: l_tax zx_rates_b.tax%TYPE;
16: l_tax_regime_code zx_rates_b.tax_regime_code%TYPE;
17:
18: l_content_owner_id zx_tax_relations_t.content_owner_id%TYPE;
19: l_group_id zx_tax_relations_t.tax_group_id%TYPE;
20: l_tax_group_code zx_tax_relations_t.tax_group_code%TYPE;
21: l_parent_tax_code zx_tax_relations_t.parent_tax_code %TYPE;
22: l_parent_precedence zx_tax_relations_t.parent_precedence%TYPE;
23: l_parent_regime_code zx_tax_relations_t.parent_regime_code %TYPE;
16: l_tax_regime_code zx_rates_b.tax_regime_code%TYPE;
17:
18: l_content_owner_id zx_tax_relations_t.content_owner_id%TYPE;
19: l_group_id zx_tax_relations_t.tax_group_id%TYPE;
20: l_tax_group_code zx_tax_relations_t.tax_group_code%TYPE;
21: l_parent_tax_code zx_tax_relations_t.parent_tax_code %TYPE;
22: l_parent_precedence zx_tax_relations_t.parent_precedence%TYPE;
23: l_parent_regime_code zx_tax_relations_t.parent_regime_code %TYPE;
24: l_child_tax_code zx_tax_relations_t.child_tax_code %TYPE;
17:
18: l_content_owner_id zx_tax_relations_t.content_owner_id%TYPE;
19: l_group_id zx_tax_relations_t.tax_group_id%TYPE;
20: l_tax_group_code zx_tax_relations_t.tax_group_code%TYPE;
21: l_parent_tax_code zx_tax_relations_t.parent_tax_code %TYPE;
22: l_parent_precedence zx_tax_relations_t.parent_precedence%TYPE;
23: l_parent_regime_code zx_tax_relations_t.parent_regime_code %TYPE;
24: l_child_tax_code zx_tax_relations_t.child_tax_code %TYPE;
25: l_child_precedence zx_tax_relations_t.child_precedence%TYPE;
18: l_content_owner_id zx_tax_relations_t.content_owner_id%TYPE;
19: l_group_id zx_tax_relations_t.tax_group_id%TYPE;
20: l_tax_group_code zx_tax_relations_t.tax_group_code%TYPE;
21: l_parent_tax_code zx_tax_relations_t.parent_tax_code %TYPE;
22: l_parent_precedence zx_tax_relations_t.parent_precedence%TYPE;
23: l_parent_regime_code zx_tax_relations_t.parent_regime_code %TYPE;
24: l_child_tax_code zx_tax_relations_t.child_tax_code %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;
19: l_group_id zx_tax_relations_t.tax_group_id%TYPE;
20: l_tax_group_code zx_tax_relations_t.tax_group_code%TYPE;
21: l_parent_tax_code zx_tax_relations_t.parent_tax_code %TYPE;
22: l_parent_precedence zx_tax_relations_t.parent_precedence%TYPE;
23: l_parent_regime_code zx_tax_relations_t.parent_regime_code %TYPE;
24: l_child_tax_code zx_tax_relations_t.child_tax_code %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;
20: l_tax_group_code zx_tax_relations_t.tax_group_code%TYPE;
21: l_parent_tax_code zx_tax_relations_t.parent_tax_code %TYPE;
22: l_parent_precedence zx_tax_relations_t.parent_precedence%TYPE;
23: l_parent_regime_code zx_tax_relations_t.parent_regime_code %TYPE;
24: l_child_tax_code zx_tax_relations_t.child_tax_code %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:
21: l_parent_tax_code zx_tax_relations_t.parent_tax_code %TYPE;
22: l_parent_precedence zx_tax_relations_t.parent_precedence%TYPE;
23: l_parent_regime_code zx_tax_relations_t.parent_regime_code %TYPE;
24: l_child_tax_code zx_tax_relations_t.child_tax_code %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;
22: l_parent_precedence zx_tax_relations_t.parent_precedence%TYPE;
23: l_parent_regime_code zx_tax_relations_t.parent_regime_code %TYPE;
24: l_child_tax_code zx_tax_relations_t.child_tax_code %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;
23: l_parent_regime_code zx_tax_relations_t.parent_regime_code %TYPE;
24: l_child_tax_code zx_tax_relations_t.child_tax_code %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;
37: l_charge_flag CHAR;
38:
39: l_alphanumeric_result zx_process_results.alphanumeric_result%TYPE;
40:
41: g_group_id zx_tax_relations_t.tax_group_id%TYPE;
42: g_child_tax_code zx_tax_relations_t.child_tax_code%TYPE;
43: g_child_regime_code zx_tax_relations_t.child_regime_code%TYPE;
44:
45: l_condition_grp_id zx_condition_groups_b.condition_group_id%TYPE;
38:
39: l_alphanumeric_result zx_process_results.alphanumeric_result%TYPE;
40:
41: g_group_id zx_tax_relations_t.tax_group_id%TYPE;
42: g_child_tax_code zx_tax_relations_t.child_tax_code%TYPE;
43: g_child_regime_code zx_tax_relations_t.child_regime_code%TYPE;
44:
45: l_condition_grp_id zx_condition_groups_b.condition_group_id%TYPE;
46: l_condition_grp_cd zx_condition_groups_b.condition_group_code%TYPE;
39: l_alphanumeric_result zx_process_results.alphanumeric_result%TYPE;
40:
41: g_group_id zx_tax_relations_t.tax_group_id%TYPE;
42: g_child_tax_code zx_tax_relations_t.child_tax_code%TYPE;
43: g_child_regime_code zx_tax_relations_t.child_regime_code%TYPE;
44:
45: l_condition_grp_id zx_condition_groups_b.condition_group_id%TYPE;
46: l_condition_grp_cd zx_condition_groups_b.condition_group_code%TYPE;
47:
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
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
102: AND grp.tax_code_id = NVL(zx_rate.source_id, zx_rate.tax_rate_id)
103: AND grp.tax_code_id = tax_rel_upg.child_tax_code_id --* new condition added
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
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
134: AND grp.tax_code_id = NVL(zx_rate.source_id, zx_rate.tax_rate_id)
135: AND grp.tax_code_id = tax_rel_upg.child_tax_code_id
149: Child_regime_code ,
150: Child_Taxable_basis ,
151: branch ,
152: content_owner_id
153: FROM zx_tax_relations_t
154: -- START WITH Parent_Regime_code IS NULL --* changed crsr
155: CONNECT BY PRIOR child_tax_code = parent_Tax_code
156: ORDER BY group_id, child_tax_code, child_precedence DESC;
157: */
719: PROCEDURE CREATE_FORMULA
720: (--for zx_formula_b
721: p_taxable_basis IN ar_vat_tax_all.taxable_basis%TYPE,
722: p_formula_code IN zx_formula_b.formula_code%TYPE,
723: p_child_regime_code IN zx_tax_relations_t.child_regime_code %TYPE,
724: p_child_tax_code IN zx_tax_relations_t.child_tax_code %TYPE,
725: p_enabled_flag IN ar_vat_tax_all.enabled_flag%TYPE,
726: p_discount_flag IN CHAR,
727: p_charge_flag IN CHAR,
720: (--for zx_formula_b
721: p_taxable_basis IN ar_vat_tax_all.taxable_basis%TYPE,
722: p_formula_code IN zx_formula_b.formula_code%TYPE,
723: p_child_regime_code IN zx_tax_relations_t.child_regime_code %TYPE,
724: p_child_tax_code IN zx_tax_relations_t.child_tax_code %TYPE,
725: p_enabled_flag IN ar_vat_tax_all.enabled_flag%TYPE,
726: p_discount_flag IN CHAR,
727: p_charge_flag IN CHAR,
728: -- for zx_formula_details
725: p_enabled_flag IN ar_vat_tax_all.enabled_flag%TYPE,
726: p_discount_flag IN CHAR,
727: p_charge_flag IN CHAR,
728: -- for zx_formula_details
729: p_parent_regime_code IN zx_tax_relations_t.parent_regime_code %TYPE,
730: p_parent_tax_code IN zx_tax_relations_t.parent_tax_code %TYPE,
731: p_group_id IN zx_tax_relations_t.tax_group_id%TYPE, --(used in where condition)
732: p_content_owner_id IN zx_rates_b.content_owner_id%TYPE,
733: p_start_date IN ar_vat_tax_all.start_date%TYPE,
726: p_discount_flag IN CHAR,
727: p_charge_flag IN CHAR,
728: -- for zx_formula_details
729: p_parent_regime_code IN zx_tax_relations_t.parent_regime_code %TYPE,
730: p_parent_tax_code IN zx_tax_relations_t.parent_tax_code %TYPE,
731: p_group_id IN zx_tax_relations_t.tax_group_id%TYPE, --(used in where condition)
732: p_content_owner_id IN zx_rates_b.content_owner_id%TYPE,
733: p_start_date IN ar_vat_tax_all.start_date%TYPE,
734: p_end_date IN ar_vat_tax_all.end_date%TYPE,
727: p_charge_flag IN CHAR,
728: -- for zx_formula_details
729: p_parent_regime_code IN zx_tax_relations_t.parent_regime_code %TYPE,
730: p_parent_tax_code IN zx_tax_relations_t.parent_tax_code %TYPE,
731: p_group_id IN zx_tax_relations_t.tax_group_id%TYPE, --(used in where condition)
732: p_content_owner_id IN zx_rates_b.content_owner_id%TYPE,
733: p_start_date IN ar_vat_tax_all.start_date%TYPE,
734: p_end_date IN ar_vat_tax_all.end_date%TYPE,
735: p_tax_regime_code IN zx_rates_b.tax_regime_code %TYPE,
967: fnd_global.prog_appl_id ,--Program Application ID
968: fnd_global.conc_program_id ,--Program Id
969: fnd_global.conc_login_id ,--Program Login ID
970: 1
971: FROM zx_tax_relations_t t
972: WHERE t.child_regime_code = p_child_regime_code
973: AND t.child_tax_code = p_child_tax_code
974: AND t.tax_group_id = p_group_id
975: AND NOT EXISTS (SELECT 1