DBA Data[Home] [Help]

APPS.ZX_TCM_CONTROL_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 1543: p_site_use_id IN HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,

1539: PROCEDURE Do_Get_Reg_Site_Uses
1540: (p_party_tax_profile_id IN NUMBER,
1541: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
1542: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
1543: p_site_use_id IN HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,
1544: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1545: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
1546: x_return_status OUT NOCOPY VARCHAR2,
1547: x_ret_record_level OUT NOCOPY VARCHAR2,

Line 2078: p_site_use_id IN HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,

2074: PROCEDURE Do_Get_Reg_Site_Uses
2075: (p_party_tax_profile_id IN NUMBER,
2076: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
2077: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
2078: p_site_use_id IN HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,
2079: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
2080: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
2081: x_return_status OUT NOCOPY VARCHAR2,
2082: x_ret_record_level OUT NOCOPY VARCHAR2,

Line 2108: FROM hz_cust_site_uses_all csu

2104: ,nvl(csu.Tax_Code,caa.tax_code) tax_code
2105: ,nvl(csu.Tax_Rounding_rule,caa.tax_rounding_rule) tax_rounding_rule
2106: ,nvl(csu.tax_header_level_flag, caa.tax_header_level_flag) tax_header_level_flag
2107: ,csu.Tax_Classification
2108: FROM hz_cust_site_uses_all csu
2109: ,hz_cust_acct_sites cas
2110: ,hz_cust_accounts caa
2111: WHERE csu.site_use_id = p_site_use_id
2112: AND csu.cust_acct_site_id = p_account_site_id

Line 2451: p_site_use_id IN HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE,

2447: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
2448: p_jurisdiction_code IN ZX_JURISDICTIONS_B.TAX_JURISDICTION_CODE%TYPE,
2449: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
2450: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
2451: p_site_use_id IN HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE,
2452: p_zx_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
2453: p_ret_record_level OUT NOCOPY VARCHAR2,
2454: p_return_status OUT NOCOPY VARCHAR2) IS
2455: