[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select upper(tax_condition_clause) tax_condition_clause,
upper(tax_condition_entity) tax_condition_entity,
upper(tax_condition_field) tax_condition_field,
upper(tax_condition_operator) tax_condition_operator,
upper(tax_condition_value) tax_condition_value
from ar_tax_condition_lines_all
where tax_condition_id = c_cec_id
order by display_order;
select upper(tax_condition_action_code) tax_condition_action_code,
decode(upper(tax_condition_action_code),
'USER_MESSAGE',tax_condition_action_value,
'DEFAULT_TAX_CODE', tax_condition_action_value,
upper(tax_condition_action_value)) tax_condition_action_value
from ar_tax_condition_actions_all
where tax_condition_id = c_cec_id
and tax_condition_action_type = c_action_type
order by display_order;
pr_action_rec_tbl.delete;
select
loc.COUNTRY,
loc.TOWN_OR_CITY,
loc.REGION_1,
loc.REGION_2,
loc.REGION_3,
loc.ADDRESS_LINE_1,
loc.ADDRESS_LINE_2,
loc.ADDRESS_LINE_3,
loc.POSTAL_CODE,
loc.TELEPHONE_NUMBER_1,
loc.TELEPHONE_NUMBER_2,
loc.TELEPHONE_NUMBER_3,
loc.STYLE,
loc.LOCATION_ID
from hr_locations_all loc,
fnd_descr_flex_contexts fnd
where loc.location_id = c_location_id
AND loc.style = fnd.descriptive_flex_context_code
AND fnd.application_id = 800 -- Application_short_name 'PER'
AND fnd.descriptive_flexfield_name = 'Address Location'
AND fnd.enabled_flag IN ('Y', 'y')
AND NVL (loc.business_group_id, NVL (hr_general.get_business_group_id, -99)) =
NVL (hr_general.get_business_group_id, NVL (loc.business_group_id, -99));
select location_id
from hr_organization_units
where organization_id = c_organization_id;
select site.TAX_CLASSIFICATION,
site.cust_acct_site_id,
site.site_use_id
from HZ_CUST_SITE_USES_ALL site
where site.site_use_id = c_site_use_id;
select loc.COUNTRY,
loc.STATE,
loc.COUNTY,
loc.PROVINCE,
loc.CITY,
acct_site.CUST_ACCT_SITE_ID
from HZ_PARTY_SITES PARTY_SITE,
-- HZ_LOC_ASSIGNMENTS LOC_ASSIGN,
HZ_LOCATIONS LOC,
HZ_CUST_ACCT_SITES_ALL ACCT_SITE
WHERE ACCT_SITE.PARTY_SITE_ID = PARTY_SITE.PARTY_SITE_ID AND
LOC.LOCATION_ID = PARTY_SITE.LOCATION_ID AND
-- LOC.LOCATION_ID = LOC_ASSIGN.LOCATION_ID AND
-- NVL(ACCT_SITE.ORG_ID, -99) = NVL(LOC_ASSIGN.ORG_ID, -99) AND
ACCT_SITE.CUST_ACCT_SITE_ID = c_address_id;
select organization_name
from org_organization_definitions org
where l_set_of_books_id = org.set_of_books_id
and org.operating_unit = l_org_id
and org.organization_id = g_cec_product_org_id;
SELECT ZP.PARTY_TAX_PROFILE_ID,Upper(SU.TAX_REFERENCE)
FROM HZ_CUST_SITE_USES_ALL SU,
HZ_CUST_ACCT_SITES_ALL CAS,
HZ_PARTY_SITES PS,
ZX_PARTY_TAX_PROFILE ZP
WHERE SU.SITE_USE_ID = c_site_use_id AND
SU.CUST_ACCT_SITE_ID = CAS.CUST_ACCT_SITE_ID AND
CAS.PARTY_SITE_ID = PS.PARTY_SITE_ID AND
ZP.PARTY_ID = PS.PARTY_SITE_ID AND
ZP.PARTY_TYPE_CODE = 'THIRD_PARTY_SITE';
SELECT ZP.PARTY_TAX_PROFILE_ID,Upper(PARTY.TAX_REFERENCE)
FROM HZ_CUST_ACCOUNTS CA,
HZ_PARTIES PARTY,
ZX_PARTY_TAX_PROFILE ZP
WHERE CA.CUST_ACCOUNT_ID = c_cust_id AND
CA.PARTY_ID = PARTY.PARTY_ID AND
PARTY.PARTY_ID = ZP.PARTY_ID AND
ZP.PARTY_TYPE_CODE = 'THIRD_PARTY';
SELECT COUNT(*) INTO l_count FROM ZX_REGISTRATIONS
WHERE PARTY_TAX_PROFILE_ID = l_party_tax_profile_id;
SELECT REGISTRATION_NUMBER INTO l_reg_number
FROM ZX_REGISTRATIONS
WHERE PARTY_TAX_PROFILE_ID = l_party_tax_profile_id;
SELECT REGISTRATION_NUMBER INTO l_reg_number
FROM ZX_REGISTRATIONS
WHERE PARTY_TAX_PROFILE_ID = l_party_tax_profile_id
AND DEFAULT_REGISTRATION_FLAG = 'Y';
SELECT COUNT(*) INTO l_count FROM ZX_REGISTRATIONS
WHERE PARTY_TAX_PROFILE_ID = l_party_tax_profile_id;
SELECT REGISTRATION_NUMBER INTO l_reg_number
FROM ZX_REGISTRATIONS
WHERE PARTY_TAX_PROFILE_ID = l_party_tax_profile_id;
SELECT REGISTRATION_NUMBER INTO l_reg_number
FROM ZX_REGISTRATIONS
WHERE PARTY_TAX_PROFILE_ID = l_party_tax_profile_id
AND DEFAULT_REGISTRATION_FLAG = 'Y';
SELECT item_type
INTO l_temp
FROM MTL_SYSTEM_ITEMS
WHERE inventory_item_id = g_cec_product_id
AND organization_id =
nvl(g_cec_product_org_id, g_cec_so_organization_id);
| update_pr_stats_rec_tbl |
| |
| DESCRIPTION |
| This function updates stats_rec_tbl with status of each condition to |
| be compared. |
| |
| SCOPE - Private |
| |
*----------------------------------------------------------------------------*/
procedure update_pr_stats_rec_tbl(p_classification IN VARCHAR2,
p_index IN NUMBER,
p_flag IN BOOLEAN) is
begin
g_current_runtime_level := FND_LOG.G_CURRENT_RUNTIME_LEVEL;
'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.update_pr_stats_rec_tbl.BEGIN',
'ZX_TDS_PROCESS_CEC_PVT.update_pr_stats_rec_tbl (+)');
'ZX.PLSQL.ZX_TDS_PROCESS_CEC_PVT.update_pr_stats_rec_tbl.END',
'ZX_TDS_PROCESS_CEC_PVT.update_pr_stats_rec_tbl (-)');
end update_pr_stats_rec_tbl;
update_pr_stats_rec_tbl(p_classification => p_classification,
p_index => IDX_TAX_CODE,
p_flag => l_return_val);
update_pr_stats_rec_tbl(p_classification => p_classification,
p_index => IDX_SHIP_TO,
p_flag => l_return_val);
update_pr_stats_rec_tbl(p_classification => p_classification,
p_index => IDX_SHIP_FROM,
p_flag => l_return_val);
update_pr_stats_rec_tbl(p_classification => p_classification,
p_index => IDX_BILL_TO,
p_flag => l_return_val);
update_pr_stats_rec_tbl(p_classification => p_classification,
p_index => IDX_POO,
p_flag => l_return_val);
update_pr_stats_rec_tbl(p_classification => p_classification,
p_index => IDX_POA,
p_flag => l_return_val);
update_pr_stats_rec_tbl(p_classification => p_classification,
p_index => IDX_TRX,
p_flag => l_return_val);
update_pr_stats_rec_tbl(p_classification => p_classification,
p_index => IDX_ITEM,
p_flag => l_return_val);
select lookup_code
from ar_lookups
where LOOKUP_TYPE = 'ARTAXVDR_LOC_QUALIFIER'
and enabled_flag = 'Y'
and trunc(c_trx_date) between
trunc(start_date_active) and
trunc(nvl(end_date_active, c_trx_date));
p_action_rec_tbl.delete;