APPS.AR_LOCVS_PKG dependencies on AR_VAT_TAX_ALL

Line 68: | This cursor selects from multi-org table AR_VAT_TAX_ALL using C_ORG_ID |

64: | ar_location_tax_account_c |
65: | |
66: | DESCRIPTION |
67: | Return the tax account id from ar_vat_tax where tax type is LOCATION |
68: | This cursor selects from multi-org table AR_VAT_TAX_ALL using C_ORG_ID |
69: +-------------------------------------------------------------------------*/
70:
71: CURSOR ar_location_tax_account_c (c_org_id in number) IS
72: select

Line 83: from ar_vat_tax_all vat

79: ADJ_NON_REC_TAX_CCID,
80: EDISC_NON_REC_TAX_CCID,
81: UNEDISC_NON_REC_TAX_CCID,
82: FINCHRG_NON_REC_TAX_CCID
83: from ar_vat_tax_all vat
84: where tax_type='LOCATION'
85: and org_id = c_org_id
86: and trunc(sysdate) between start_date and nvl(end_date, trunc(sysdate));
87: