[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
SELECT id
FROM okl_trx_types_tl
WHERE name = cp_name
AND LANGUAGE = cp_language;-- Fix for 3637102
SELECT stm.khr_id khr_id,
TRUNC ( ste.stream_element_date) due_date,
stm.kle_id kle_id,
ste.id stream_ele_id,
stm.sty_id sty_id,
ste.amount amount,
chr.contract_number contract_number
FROM okl_strm_elements ste,
okl_streams stm,
OKC_K_HEADERS_B chr, -- Added for Org,
okl_k_headers oklchr,
OKL_STRM_TMPT_LINES_UV stl
WHERE ste.stream_element_date >= NVL (l_from_bill_date, ste.stream_element_date)
AND ste.stream_element_date <= NVL (l_to_bill_date, SYSDATE)
AND stm.id = ste.stm_id
AND ste.date_billed IS NULL
AND stm.active_yn = 'Y'
AND stm.say_code = 'CURR'
AND stl.primary_yn = 'Y'
AND stl.pdt_id = oklchr.pdt_id
AND (stl.start_date <= chr.start_date)
AND (stl.end_date >= chr.start_date OR stl.end_date IS NULL)
AND stl.primary_sty_purpose = 'INSURANCE_PAYABLE'
AND stl.primary_sty_id = stm.sty_id
AND chr.ID = stm.khr_id
AND chr.id = oklchr.id;
SELECT id
FROM okl_trx_types_tl
WHERE name = cp_name
AND language = cp_language;
SELECT Meaning
FROM fnd_lookups
WHERE lookup_type = 'OKL_TRANSACTION_TYPE_CLASS'
and lookup_code ='DISBURSEMENT';
OKL_INSURANCE_POLICIES_PUB.insert_ap_request(
p_api_version =>l_api_version,
p_init_msg_list => Okc_Api.G_TRUE,
x_return_status =>l_return_status,
x_msg_count => l_msg_count,
x_msg_data =>l_msg_data,
p_tap_id => NULL,
p_credit_amount =>c_streams_rec.amount,
p_credit_sty_id =>c_streams_rec.STY_ID,
p_khr_id => c_streams_rec.khr_id,
p_kle_id =>c_streams_rec.kle_id,
p_invoice_date =>c_streams_rec.due_date,
p_trx_id => l_trx_type_id);
Okl_Streams_Pub.update_stream_elements
(l_api_version
,Okc_Api.G_TRUE
,l_return_status
,l_msg_count
,l_msg_data
,l_selv_rec
,x_selv_rec);
SELECT 'Y'
FROM wf_event_subscriptions a,
wf_events b
WHERE a.event_filter_guid = b.guid
AND a.status = 'ENABLED'
AND b.name = p_event_name
AND rownum = 1;
select okl_wf_item_s.nextval INTO l_seq FROM DUAL ;
l_parameter_list.DELETE;
SELECT IPYB.KHR_ID
,OCHR.CONTRACT_NUMBER
,IPYB.ID
,OCHR.CUST_ACCT_ID --Bug 4177206
FROM OKL_INS_POLICIES_B IPYB
,OKC_K_HEADERS_B OCHR
WHERE (IPYB.IPY_TYPE = 'THIRD_PARTY_POLICY' OR
(IPYB.IPY_TYPE = 'LEASE_POLICY' AND
IPYB.ISS_CODE = 'ACTIVE')) AND
trunc(IPYB.DATE_TO) = trunc(SYSDATE) + ls_remder_num_days
AND OCHR.ID = IPYB.KHR_ID;
SELECT hcp_email.email_address
FROM hz_cust_account_roles hcar ,
hz_contact_points hcp_email
WHERE hcar.cust_account_id = p_cust_acct_id
AND hcar.cust_acct_site_id IS NULL
AND hcar.status = 'A'
AND hcar.role_type = 'CONTACT'
AND hcp_email.contact_point_type = 'EMAIL'
AND hcp_email.owner_table_id = hcar.party_id
AND hcp_email.owner_table_name = 'HZ_PARTIES'
AND hcp_email.primary_flag = 'Y';
SELECT USER_PROFILE_OPTION_NAME
FROM FND_PROFILE_OPTIONS_VL
WHERE PROFILE_OPTION_NAME = p_profile_code;
Fnd_File.PUT_LINE(Fnd_File.OUTPUT,'No Document is selected');
Fnd_File.PUT_LINE(Fnd_File.OUTPUT,'No Document is selected');
SELECT STE_CODE
FROM OKC_K_HEADERS_V KHR , OKC_STATUSES_B OST
WHERE KHR.ID = p_khr_id
AND KHR.STS_CODE = OST.CODE;
SELECT
ID,
ADJUSTMENT,
CALCULATED_PREMIUM,
OBJECT_VERSION_NUMBER,
AGENCY_NUMBER,
SFWT_FLAG,
IPF_CODE,
INT_ID,
KHR_ID,
ISU_ID,
IPT_ID,
IPY_ID,
IPE_CODE,
CRX_CODE,
AGENCY_SITE_ID,
ISS_CODE,
KLE_ID,
AGENT_SITE_ID,
IPY_TYPE,
POLICY_NUMBER,
QUOTE_YN,
ENDORSEMENT,
INSURANCE_FACTOR,
COVERED_AMOUNT,
ADJUSTED_BY_ID,
FACTOR_VALUE,
DATE_QUOTED,
SALES_REP_ID,
DATE_PROOF_REQUIRED,
DATE_QUOTE_EXPIRY,
DEDUCTIBLE,
PAYMENT_FREQUENCY,
DATE_PROOF_PROVIDED,
DATE_FROM,
NAME_OF_INSURED,
DATE_TO,
DESCRIPTION,
ON_FILE_YN,
PREMIUM,
COMMENTS,
ACTIVATION_DATE,
PRIVATE_LABEL_YN,
LESSOR_INSURED_YN,
LESSOR_PAYEE_YN,
CANCELLATION_DATE,
CANCELLATION_COMMENT,
AGENT_YN,
ATTRIBUTE_CATEGORY,
ATTRIBUTE1,
ATTRIBUTE2,
ATTRIBUTE3,
ATTRIBUTE4,
ATTRIBUTE5,
ATTRIBUTE6,
ATTRIBUTE7,
ATTRIBUTE8,
ATTRIBUTE9,
ATTRIBUTE10,
ATTRIBUTE11,
ATTRIBUTE12,
ATTRIBUTE13,
ATTRIBUTE14,
ATTRIBUTE15,
ORG_ID,
REQUEST_ID,
PROGRAM_APPLICATION_ID,
PROGRAM_ID,
PROGRAM_UPDATE_DATE,
CREATED_BY,
CREATION_DATE,
LAST_UPDATED_BY,
LAST_UPDATE_DATE,
LAST_UPDATE_LOGIN
FROM Okl_Ins_Policies_V
WHERE okl_ins_policies_v.id = p_id;
l_ipyv_rec.PROGRAM_UPDATE_DATE,
l_ipyv_rec.CREATED_BY,
l_ipyv_rec.CREATION_DATE,
l_ipyv_rec.LAST_UPDATED_BY,
l_ipyv_rec.LAST_UPDATE_DATE,
l_ipyv_rec.LAST_UPDATE_LOGIN;
SELECT IPYB.KHR_ID
,OCHR.CONTRACT_NUMBER
,OCHR.CUST_ACCT_ID -- Bug 4177206
FROM OKL_INS_POLICIES_B IPYB
,OKC_K_HEADERS_B OCHR
WHERE IPYB.IPY_TYPE = 'THIRD_PARTY_POLICY' AND
IPYB.DATE_PROOF_REQUIRED < SYSDATE AND
IPYB.DATE_PROOF_REQUIRED >= SYSDATE - l_no_of_days AND
IPYB.DATE_PROOF_PROVIDED IS NULL
AND OCHR.ID = IPYB.KHR_ID;
SELECT hcp_email.email_address
FROM hz_cust_account_roles hcar ,
hz_contact_points hcp_email
WHERE hcar.cust_account_id = p_cust_acct_id
AND hcar.cust_acct_site_id IS NULL
AND hcar.status = 'A'
AND hcar.role_type = 'CONTACT'
AND hcp_email.contact_point_type = 'EMAIL'
AND hcp_email.owner_table_id = hcar.party_id
AND hcp_email.owner_table_name = 'HZ_PARTIES'
AND hcp_email.primary_flag = 'Y';
SELECT USER_PROFILE_OPTION_NAME
FROM FND_PROFILE_OPTIONS_VL
WHERE PROFILE_OPTION_NAME = p_profile_code;
Fnd_File.PUT_LINE(Fnd_File.OUTPUT,'No Document is Selected');
SELECT OKHB.ID
,OKHB.STS_CODE
,OKHB.START_DATE
,OKHB.END_DATE
,OKHB.CONTRACT_NUMBER
--Bug # 6318957 SSDESHPA Changes Start
,OKHB.ORG_ID
--Bug # 6318957 SSDESHPA Changes End
FROM OKC_K_HEADERS_B OKHB
,OKL_K_HEADERS OKLH
,OKC_STATUSES_B OKSB
WHERE OKSB.STE_CODE = 'ACTIVE' AND
OKHB.STS_CODE = OKSB.CODE AND
OKHB.SCS_CODE = 'LEASE' AND
OKHB.END_DATE > SYSDATE AND
OKLH.ID = OKHB.ID AND
(OKHB.START_DATE + l_no_of_days ) <= SYSDATE
AND OKHB.ID NOT IN
(SELECT IPYB.KHR_ID
FROM OKL_INS_POLICIES_B IPYB
WHERE IPYB.IPY_TYPE = 'LEASE_POLICY' AND
IPYB.QUOTE_YN = 'N' AND
IPYB.ISS_CODE = 'ACTIVE' AND
(SYSDATE - l_no_of_days ) BETWEEN IPYB.DATE_FROM AND IPYB.DATE_TO AND
IPYB.KHR_ID = OKHB.ID
UNION
SELECT IPYB.KHR_ID
FROM OKL_INS_POLICIES_B IPYB
WHERE IPYB.IPY_TYPE = 'THIRD_PARTY_POLICY' AND
(IPYB.DATE_PROOF_PROVIDED IS NOT NULL OR
(IPYB.DATE_PROOF_PROVIDED IS NULL AND
IPYB.DATE_PROOF_REQUIRED >= SYSDATE)) AND
IPYB.KHR_ID = OKHB.ID
)
ORDER BY OKHB.CONTRACT_NUMBER;
SELECT OIR.RANKING_SEQ, OIR.ISU_ID
FROM OKL_INSURER_RANKINGS OIR,OKL_INS_PRODUCTS_B IPTB
WHERE OIR.ISU_ID = IPTB.ISU_ID
AND OIR.IC_CODE = ls_country_code
AND IPT_TYPE = 'LEASE_PRODUCT'
AND l_factor BETWEEN FACTOR_MIN AND FACTOR_MAX
AND SYSDATE BETWEEN oir.DATE_FROM AND DECODE(oir.DATE_TO,NULL,SYSDATE,oir.DATE_TO)
ORDER BY RANKING_SEQ ;
SELECT IPYB.DATE_TO
FROM OKL_INS_POLICIES_B IPYB
WHERE IPYB.IPY_TYPE = 'THIRD_PARTY_POLICY'
AND IPYB.QUOTE_YN = 'N'
AND IPYB.DATE_PROOF_PROVIDED IS NOT NULL
AND IPYB.KHR_ID = l_khr_id
UNION
SELECT IPYB.DATE_TO
FROM OKL_INS_POLICIES_B IPYB
WHERE IPYB.IPY_TYPE = 'LEASE_POLICY'
AND IPYB.QUOTE_YN = 'N'
AND IPYB.ISS_CODE IN ('ACTIVE','EXPIRED','CANCELLED', 'PENDING')
AND IPYB.KHR_ID = l_khr_id
ORDER BY 1 DESC;
SELECT SUM(KLE.CAPITAL_AMOUNT) --,SUM(KLE.OEC)
FROM OKC_K_LINES_B CLEB,OKL_K_LINES KLE
WHERE CLEB.ID = KLE.ID
AND CLEB.DNZ_CHR_ID = p_khr_id
AND CLEB.CLE_ID IS NULL
GROUP BY CLEB.DNZ_CHR_ID ;
select cle.id
FROM OKC_K_LINES_B CLE ,
OKC_LINE_STYLES_B LST,
OKL_K_LINES kle
where cle.dnz_chr_id = p_khr_id
AND lst.lty_code ='FREE_FORM1'
AND lst.id = cle.lse_id
AND KLE.id = cle.id ;
SELECT RUL.RULE_INFORMATION1,RUL.RULE_INFORMATION2
FROM OKC_RULES_V RUL, OKC_RULE_GROUPS_V GRUL
WHERE GRUL.RGD_CODE = 'INSRUL'
AND RUL.RGP_ID = GRUL.ID
AND RUL.rule_information_category = 'INCUST'
AND GRUL.CHR_ID = p_khr_id ;
SELECT RUL.RULE_INFORMATION1
FROM OKC_RULES_V RUL, OKC_RULE_GROUPS_V GRUL
WHERE GRUL.RGD_CODE = 'INVRUL'
AND RUL.RGP_ID = GRUL.ID
AND RUL.rule_information_category = 'INVNIN'
AND GRUL.CHR_ID = p_khr_id ;
SELECT USER_PROFILE_OPTION_NAME
FROM FND_PROFILE_OPTIONS_VL
WHERE PROFILE_OPTION_NAME = p_profile_code;
SELECT IPY_ID
INTO l_policy_id
FROM OKL_INS_POLICIES_B
WHERE ID =x_message ;