The following lines contain the word 'select', 'insert', 'update' or 'delete':
, p_operation IN VARCHAR2 DEFAULT 'UPDATE_INDEX_RENT'
, p_index_lease_number IN OUT NOCOPY VARCHAR2
, x_index_lease_id IN OUT NOCOPY NUMBER
, x_lease_id OUT NOCOPY NUMBER
, x_org_id IN OUT NOCOPY NUMBER
, x_index_id OUT NOCOPY NUMBER
, x_return_status OUT NOCOPY VARCHAR2
)
IS
l_api_name CONSTANT VARCHAR2 (30) := p_operation;
SELECT index_lease_id
,index_lease_number
,lease_id
,org_id
,index_id
FROM pn_index_leases_all
WHERE index_lease_number = p_index_lease_number
AND org_id=x_org_id;
SELECT index_lease_id
,index_lease_number
,lease_id
,org_id
,index_id
FROM pn_index_leases_all
WHERE index_lease_id = x_index_lease_id
AND org_id=x_org_id;
SELECT flv.lookup_code
FROM fnd_lookup_values_vl flv
WHERE flv.lookup_type = p_lookup_type
AND TRUNC (SYSDATE) BETWEEN TRUNC (NVL (flv.start_date_active
, SYSDATE))
AND TRUNC (NVL (flv.end_date_active
, SYSDATE))
AND flv.enabled_flag = 'Y'
AND flv.meaning = p_lookup_meaning;
SELECT flv.lookup_code
FROM fnd_lookup_values_vl flv
WHERE flv.lookup_type = p_lookup_type
AND TRUNC (SYSDATE) BETWEEN TRUNC (NVL (flv.start_date_active
, SYSDATE))
AND TRUNC (NVL (flv.end_date_active
, SYSDATE))
AND flv.enabled_flag = 'Y'
AND flv.lookup_code = x_lookup_type_code;
SELECT PL.lease_id lease_id
,PL.lease_class_code lease_class_code
,PLD.lease_commencement_date commencement_date
,PLD.lease_termination_date termination_date
,PLD.lease_execution_date lease_execution_date
,PLD.lease_extension_end_date
FROM pn_leases_all PL
,pn_lease_details_all PLD
WHERE PLD.lease_id = PL.lease_id
AND PL.lease_id = x_lease_id
AND PLD.org_id = PL.org_id
AND PL.org_id = p_org_id;
SELECT PL.lease_id lease_id
,PL.lease_class_code lease_class_code
,PLD.lease_commencement_date commencement_date
,PLD.lease_termination_date termination_date
,PLD.lease_execution_date lease_execution_date
,PLD.lease_extension_end_date
FROM pn_leases_all PL
,pn_lease_details_all PLD
WHERE PL.lease_num = p_lease_number
AND PLD.lease_id = PL.lease_id
-- AND PL.lease_id = x_lease_id
AND PLD.org_id = PL.org_id
AND PL.org_id = p_org_id;
SELECT PL.lease_id lease_id
,PL.lease_class_code lease_class_code
,PLD.lease_commencement_date commencement_date
,PLD.lease_termination_date termination_date
,PLD.lease_execution_date lease_execution_date
,PLD.lease_extension_end_date
FROM pn_leases_all PL
,pn_lease_details_all PLD
WHERE PL.name = p_lease_name
AND PLD.lease_id = PL.lease_id
--AND PL.lease_id = x_lease_id
AND PLD.org_id = PL.org_id
AND PL.org_id = p_org_id;
SELECT PT.location_id
FROM pn_tenancies_all PT
, pn_locations_all PL
, fnd_lookups LOC_LKP
, fnd_lookups FLG_LKP
WHERE PT.location_id = PL.location_id
AND PL.org_id = p_org_id
AND NVL(PT.occupancy_date, PT.estimated_occupancy_date)
BETWEEN PL.active_start_date
AND PL.active_end_date
AND PT.lease_id = p_lease_id
AND LOC_LKP.lookup_code = PL.LOCATION_TYPE_LOOKUP_CODE
AND LOC_LKP.lookup_type = 'PN_LOCATION_TYPE'
AND FLG_LKP.lookup_code = pt.primary_flag
AND FLG_LKP.lookup_type ='PN_YES_NO'
AND PL.location_code =p_location_code;
SELECT PT.location_id
FROM pn_tenancies_all PT
, pn_locations_all PL
, fnd_lookups LOC_LKP
, fnd_lookups FLG_LKP
WHERE PT.location_id = PL.location_id
AND PL.org_id = p_org_id
AND NVL(PT.occupancy_date, PT.estimated_occupancy_date)
BETWEEN PL.active_start_date
AND PL.active_end_date
AND PT.lease_id = p_lease_id
AND LOC_LKP.lookup_code = PL.LOCATION_TYPE_LOOKUP_CODE
AND LOC_LKP.lookup_type ='PN_LOCATION_TYPE'
AND FLG_LKP.lookup_code = pt.primary_flag
AND FLG_LKP.lookup_type ='PN_YES_NO'
AND PL.location_id = x_location_id;
SELECT index_id
FROM pn_index_history_headers
WHERE name = p_index_name;
SELECT index_id
FROM pn_index_history_headers
WHERE index_id = x_index_id;
SELECT user_id
FROM fnd_user
WHERE TRUNC (SYSDATE) BETWEEN TRUNC (NVL (start_date, SYSDATE))
AND TRUNC (NVL (end_date, SYSDATE))
AND user_name = p_user_name;
SELECT user_id
FROM fnd_user
WHERE TRUNC (SYSDATE) BETWEEN TRUNC (NVL (start_date, SYSDATE))
AND TRUNC (NVL (end_date, SYSDATE))
AND user_id = x_user_id;
SELECT pn.currency_code
, gl.user_conversion_type
, pn.conversion_type
FROM pn_currencies pn, gl_daily_conversion_types gl
WHERE pn.conversion_type = gl.conversion_type
AND pn.currency_code = x_currency_code;
SELECT DISTINCT LOOK.lookup_code lookup_code
FROM fnd_lookups LOOK
,pn_payment_terms_all TERMS
WHERE LOOK.lookup_type = 'PN_PAYMENT_TERM_TYPE'
AND LOOK.enabled_flag = 'Y'
AND TERMS.lease_id = p_lease_id
AND DECODE(TERMS.index_period_id,NULL,'APPROVED',TERMS.status)='APPROVED'
AND TERMS.payment_term_type_code=LOOK.lookup_code
AND TRUNC (SYSDATE) BETWEEN TRUNC (NVL(start_date_active, SYSDATE)) and TRUNC (NVL(end_date_active, SYSDATE))
AND currency_code = p_currency_code
AND LOOK.meaning= p_lookup_meaning;
SELECT DISTINCT LOOK.lookup_code lookup_code
FROM fnd_lookups LOOK
,pn_payment_terms_all TERMS
WHERE LOOK.lookup_type = 'PN_PAYMENT_TERM_TYPE'
AND LOOK.enabled_flag = 'Y'
AND TERMS.lease_id = p_lease_id
AND DECODE(TERMS.index_period_id,NULL,'APPROVED',TERMS.status)='APPROVED'
AND TERMS.payment_term_type_code=LOOK.lookup_code
AND TRUNC (SYSDATE) BETWEEN TRUNC (NVL(start_date_active, SYSDATE)) and TRUNC (NVL(end_date_active, SYSDATE))
AND currency_code = p_currency_code
AND LOOK.lookup_code= x_lookup_code;
SELECT term_template_id
FROM pn_term_templates_all
WHERE active = 'Y'
--AND set_of_books_id = 1001 -- change it
AND org_id = p_org_id
AND ( (term_template_type = p_termtemp_type)
OR
( term_template_type ='NEUTRAL')
)
AND NAME = p_termtemp_name;
SELECT term_template_id
FROM pn_term_templates_all
WHERE active = 'Y'
--AND set_of_books_id = 1001 -- change it
AND org_id = p_org_id
AND ( (term_template_type = p_termtemp_type)
OR
( term_template_type ='NEUTRAL')
)
AND term_template_id = x_termtemp_id;