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_VAT_TAX_ALL

Line 8: l_child_taxable_basis ar_vat_tax_all.taxable_basis%TYPE;

4: PROCEDURE FORMULA_MIGRATION_MAIN
5: (x_return_status OUT NOCOPY VARCHAR2) IS
6: i number;
7:
8: l_child_taxable_basis ar_vat_tax_all.taxable_basis%TYPE;
9: l_tax_code ar_vat_tax_all.tax_code%TYPE;
10: l_enabled_flag ar_vat_tax_all.enabled_flag%TYPE;
11: l_start_date ar_vat_tax_all.start_date%TYPE;
12: l_end_date ar_vat_tax_all.end_date%TYPE;

Line 9: l_tax_code ar_vat_tax_all.tax_code%TYPE;

5: (x_return_status OUT NOCOPY VARCHAR2) IS
6: i number;
7:
8: l_child_taxable_basis ar_vat_tax_all.taxable_basis%TYPE;
9: l_tax_code ar_vat_tax_all.tax_code%TYPE;
10: l_enabled_flag ar_vat_tax_all.enabled_flag%TYPE;
11: l_start_date ar_vat_tax_all.start_date%TYPE;
12: l_end_date ar_vat_tax_all.end_date%TYPE;
13: l_tax_constraint_id ar_vat_tax_all.tax_constraint_id%TYPE;

Line 10: l_enabled_flag ar_vat_tax_all.enabled_flag%TYPE;

6: i number;
7:
8: l_child_taxable_basis ar_vat_tax_all.taxable_basis%TYPE;
9: l_tax_code ar_vat_tax_all.tax_code%TYPE;
10: l_enabled_flag ar_vat_tax_all.enabled_flag%TYPE;
11: l_start_date ar_vat_tax_all.start_date%TYPE;
12: l_end_date ar_vat_tax_all.end_date%TYPE;
13: l_tax_constraint_id ar_vat_tax_all.tax_constraint_id%TYPE;
14:

Line 11: l_start_date ar_vat_tax_all.start_date%TYPE;

7:
8: l_child_taxable_basis ar_vat_tax_all.taxable_basis%TYPE;
9: l_tax_code ar_vat_tax_all.tax_code%TYPE;
10: l_enabled_flag ar_vat_tax_all.enabled_flag%TYPE;
11: l_start_date ar_vat_tax_all.start_date%TYPE;
12: l_end_date ar_vat_tax_all.end_date%TYPE;
13: l_tax_constraint_id ar_vat_tax_all.tax_constraint_id%TYPE;
14:
15: l_tax zx_rates_b.tax%TYPE;

Line 12: l_end_date ar_vat_tax_all.end_date%TYPE;

8: l_child_taxable_basis ar_vat_tax_all.taxable_basis%TYPE;
9: l_tax_code ar_vat_tax_all.tax_code%TYPE;
10: l_enabled_flag ar_vat_tax_all.enabled_flag%TYPE;
11: l_start_date ar_vat_tax_all.start_date%TYPE;
12: l_end_date ar_vat_tax_all.end_date%TYPE;
13: l_tax_constraint_id ar_vat_tax_all.tax_constraint_id%TYPE;
14:
15: l_tax zx_rates_b.tax%TYPE;
16: l_tax_regime_code zx_rates_b.tax_regime_code%TYPE;

Line 13: l_tax_constraint_id ar_vat_tax_all.tax_constraint_id%TYPE;

9: l_tax_code ar_vat_tax_all.tax_code%TYPE;
10: l_enabled_flag ar_vat_tax_all.enabled_flag%TYPE;
11: l_start_date ar_vat_tax_all.start_date%TYPE;
12: l_end_date ar_vat_tax_all.end_date%TYPE;
13: l_tax_constraint_id ar_vat_tax_all.tax_constraint_id%TYPE;
14:
15: l_tax zx_rates_b.tax%TYPE;
16: l_tax_regime_code zx_rates_b.tax_regime_code%TYPE;
17:

Line 65: FROM ar_vat_tax_all vat, zx_rates_b rate

61: vat.end_date ,
62: rate.tax ,
63: rate.tax_regime_code ,
64: rate.content_owner_id
65: FROM ar_vat_tax_all vat, zx_rates_b rate
66: WHERE vat.taxable_basis IN ('AFTER_EPD', 'QUANTITY')
67: AND vat.tax_class = 'O'
68: AND vat.tax_type <> 'TAX_GROUP'
69: AND vat.vat_tax_id = NVL(rate.source_id, rate.tax_rate_id);

Line 391: FROM ar_vat_tax_all vat

387: arp_util_tax.debug('case 3:bef select');
388:
389: SELECT vat.tax_constraint_id
390: INTO l_tax_constraint_id
391: FROM ar_vat_tax_all vat
392: WHERE vat.vat_tax_id = l_tax_group_id;
393:
394: SELECT condition_group_id, condition_group_code
395: INTO l_condition_grp_id, l_condition_grp_cd

Line 529: FROM ar_vat_tax_all vat

525: arp_util_tax.debug('case 4:before select of cond grp');
526:
527: SELECT vat.tax_constraint_id
528: INTO l_tax_constraint_id
529: FROM ar_vat_tax_all vat
530: WHERE vat.vat_tax_id = l_tax_group_id;
531:
532: SELECT condition_group_id, condition_group_code
533: INTO l_condition_grp_id, l_condition_grp_cd

Line 721: p_taxable_basis IN ar_vat_tax_all.taxable_basis%TYPE,

717:
718:
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,

Line 725: p_enabled_flag IN ar_vat_tax_all.enabled_flag%TYPE,

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
729: p_parent_regime_code IN zx_tax_relations_t.parent_regime_code %TYPE,

Line 733: p_start_date IN ar_vat_tax_all.start_date%TYPE,

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,
736: p_tax_code IN zx_rates_b.tax %TYPE,
737: x_return_status OUT NOCOPY VARCHAR2) IS

Line 734: p_end_date IN ar_vat_tax_all.end_date%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,
736: p_tax_code IN zx_rates_b.tax %TYPE,
737: x_return_status OUT NOCOPY VARCHAR2) IS
738:

Line 1007: p_effective_from IN ar_vat_tax_all.start_date%TYPE ,

1003: PROCEDURE CREATE_RULES
1004: ( --parameters rqrd for zx_rules_b
1005: p_tax IN zx_rates_b.tax%TYPE ,
1006: p_tax_regime_code IN zx_rates_b.tax_regime_code%TYPE ,
1007: p_effective_from IN ar_vat_tax_all.start_date%TYPE ,
1008: p_effective_to IN ar_vat_tax_all.end_date%TYPE ,
1009: p_enabled_flag IN ar_tax_group_codes.enabled_flag%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 ,

Line 1008: p_effective_to IN ar_vat_tax_all.end_date%TYPE ,

1004: ( --parameters rqrd for zx_rules_b
1005: p_tax IN zx_rates_b.tax%TYPE ,
1006: p_tax_regime_code IN zx_rates_b.tax_regime_code%TYPE ,
1007: p_effective_from IN ar_vat_tax_all.start_date%TYPE ,
1008: p_effective_to IN ar_vat_tax_all.end_date%TYPE ,
1009: p_enabled_flag IN ar_tax_group_codes.enabled_flag%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,