[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
select PAY.NAME, PYT.term_id,
PYT.CREDIT_CHECK_FLAG, PYT.DUE_CUTOFF_DAY,
PYT.PRINTING_LEAD_DAYS, PAY.DESCRIPTION,
PYT.BASE_AMOUNT, PYT.CALC_DISCOUNT_ON_LINES_FLAG,
PYT.FIRST_INSTALLMENT_CODE, PYT.IN_USE,
PYT.PARTIAL_DISCOUNT_FLAG, PYT.ATTRIBUTE_CATEGORY,
PYT.ATTRIBUTE1, PYT.ATTRIBUTE2,
PYT.ATTRIBUTE3, PYT.ATTRIBUTE4,
PYT.ATTRIBUTE5, PYT.ATTRIBUTE6,
PYT.ATTRIBUTE7, PYT.ATTRIBUTE8,
PYT.ATTRIBUTE9, PYT.ATTRIBUTE10,
PYT.ATTRIBUTE11, PYT.ATTRIBUTE12,
PYT.ATTRIBUTE13, PYT.ATTRIBUTE14,
PYT.ATTRIBUTE15, PYT.CREATED_BY,
PYT.CREATION_DATE, PYT.LAST_UPDATE_DATE,
PYT.LAST_UPDATED_BY
from RA_TERMS_B PYT ,
RA_TERMS_TL PAY
-- B1107729 NAME column is referred from PAY instead of PYT
where lower(PAY.name) like lower(nvl(term_name, PAY.name))
and PYT.term_id = nvl(termid, PYT.term_id)
and PYT.term_id = PAY.term_id
and PAY.language = apps_base_language
and PYT.last_update_date between
nvl(start_date, PYT.last_update_date)
and nvl(end_date, PYT.last_update_date);
last_update_date out date,
last_updated_by out number,
row_to_fetch in out number,
error_status out number) is
begin
SELECT language_code
INTO apps_base_language
FROM fnd_languages
WHERE installed_flag = 'B';
created_by, creation_date, last_update_date,
last_updated_by;