DBA Data[Home] [Help]

APPS.JG_ZZ_SUMMARY_ALL_PKG dependencies on JG_ZZ_VAT_ALLOC_RULES

Line 542: , jg_zz_vat_alloc_rules alr

538: alr.tax_rec_sign_flag, alr.tax_non_rec_sign_flag) || '1',
539: alr.tax_rec_sign_flag || '1')) TAX_AMOUNT
540: FROM
541: jg_zz_vat_box_allocs AL
542: , jg_zz_vat_alloc_rules alr
543: , jg_zz_vat_trx_details JG
544: , fnd_lookup_values TLOOKUP
545: , fnd_lookup_values TBLLOOKUP
546: , jg_zz_vat_rep_status JZVRS

Line 847: , jg_zz_vat_alloc_rules ALLOCRUL

843: , AllOCBOX.allocation_rule_id ALLOCATION_RULE_ID
844: FROM jg_zz_vat_trx_details JG
845: , jg_zz_vat_rep_status JZVRS
846: , jg_zz_vat_box_allocs AllOCBOX
847: , jg_zz_vat_alloc_rules ALLOCRUL
848: WHERE JZVRS.reporting_status_id = JG.reporting_status_id
849: AND JZVRS.vat_reporting_entity_id = p_vat_rep_entity_id
850: AND JZVRS.tax_calendar_year = p_period
851: AND JG.pt_location = p_location