DBA Data[Home] [Help]

APPS.ZX_TCM_CONTROL_PKG dependencies on HZ_CUST_SITE_USES_ALL

Line 1582: p_site_use_id IN HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,

1578: PROCEDURE Do_Get_Reg_Site_Uses
1579: (p_party_tax_profile_id IN NUMBER,
1580: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
1581: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
1582: p_site_use_id IN HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,
1583: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
1584: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
1585: x_return_status OUT NOCOPY VARCHAR2,
1586: x_ret_record_level OUT NOCOPY VARCHAR2,

Line 2134: p_site_use_id IN HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,

2130: PROCEDURE Do_Get_Reg_Site_Uses
2131: (p_party_tax_profile_id IN NUMBER,
2132: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
2133: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
2134: p_site_use_id IN HZ_CUST_SITE_USES_ALL.CUST_ACCT_SITE_ID%TYPE,
2135: p_tax_determine_date IN ZX_LINES.TAX_DETERMINE_DATE%TYPE,
2136: x_get_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
2137: x_return_status OUT NOCOPY VARCHAR2,
2138: x_ret_record_level OUT NOCOPY VARCHAR2,

Line 2164: FROM hz_cust_site_uses_all csu

2160: ,nvl(csu.Tax_Code,caa.tax_code) tax_code
2161: ,nvl(csu.Tax_Rounding_rule,caa.tax_rounding_rule) tax_rounding_rule
2162: ,nvl(csu.tax_header_level_flag, caa.tax_header_level_flag) tax_header_level_flag
2163: ,csu.Tax_Classification
2164: FROM hz_cust_site_uses_all csu
2165: ,hz_cust_acct_sites cas
2166: ,hz_cust_accounts caa
2167: WHERE csu.site_use_id = p_site_use_id
2168: AND csu.cust_acct_site_id = p_account_site_id

Line 2518: p_site_use_id IN HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE,

2514: p_tax_regime_code IN ZX_REGIMES_B.TAX_REGIME_CODE%TYPE,
2515: p_jurisdiction_code IN ZX_JURISDICTIONS_B.TAX_JURISDICTION_CODE%TYPE,
2516: p_account_id IN ZX_REGISTRATIONS.ACCOUNT_ID%TYPE,
2517: p_account_site_id IN ZX_REGISTRATIONS.ACCOUNT_SITE_ID%TYPE,
2518: p_site_use_id IN HZ_CUST_SITE_USES_ALL.SITE_USE_ID%TYPE,
2519: p_zx_registration_rec OUT NOCOPY ZX_TCM_CONTROL_PKG.ZX_REGISTRATION_INFO_REC,
2520: p_ret_record_level OUT NOCOPY VARCHAR2,
2521: p_return_status OUT NOCOPY VARCHAR2) IS
2522: