[Home] [Help]
The following lines contain the word 'select', 'insert', 'update' or 'delete':
FUNCTION last_updated_by RETURN NUMBER IS
BEGIN
RETURN NVL(FND_GLOBAL.user_id,-1);
END last_updated_by;
FUNCTION last_update_date RETURN DATE IS
BEGIN
RETURN SYSDATE;
END last_update_date;
FUNCTION last_update_login RETURN NUMBER IS
BEGIN
IF FND_GLOBAL.conc_login_id = -1 OR
FND_GLOBAL.conc_login_id IS NULL
THEN
RETURN FND_GLOBAL.login_id;
END last_update_login;
FUNCTION program_update_date RETURN DATE IS
BEGIN
IF program_id IS NULL THEN
RETURN NULL;
END program_update_date;
' Select ''X'' ' ||
' From ' || p_table_name || ' ' ||
' Where exists ' ||
' (Select ' || p_col_name ||
' From ' || p_table_name ||
' Where ' || p_col_name || ' = :a1)';
vPLSQL := ' Select ''X'' ' ||
' From ' || p_table_name ||
' Where exists ' ||
' (Select ' || p_col_name ||
' From ' || p_table_name ||
' Where ' || p_col_name || ' = :a1)';
'Select Count(LOOKUP_CODE) ' ||
'From ' || p_lookup_view || ' ' ||
'Where LOOKUP_TYPE = ' || l_lookup_type || ' AND ' ||
'LOOKUP_CODE = ' || l_lookup_code || ' AND ' ||
'ENABLED_FLAG = ''Y''';
'SELECT OBJECT_VERSION_NUMBER, ' ||
' ROWID ' ||
' FROM ' || p_table_name ||
' Where ' || p_primary_key_name || ' = ' || p_primary_key_value ||
' FOR UPDATE OF ' || p_primary_key_name || ' NOWAIT'
INTO l_object_version_number,
l_rowid;
SELECT meaning
INTO l_meaning
FROM lns_lookups
WHERE lookup_type = p_lookup_type
AND lookup_code = p_lookup_code ;
select fndc.precision
FROM gl_sets_of_books sb,
fnd_currencies fndc
WHERE sb.currency_code = fndc.currency_code
and fndc.currency_code = p_to_currency;
select fndc.precision
FROM fnd_currencies fndc
WHERE fndc.currency_code = p_to_currency;
SELECT sb.currency_code into l_to_currency
FROM lns_system_options so,
gl_sets_of_books sb
WHERE sb.set_of_books_id = so.set_of_books_id;
select org_id into l_org_id
from lns_system_options;
select org_id into l_org_id
from lns_loan_headers_all
where loan_id = p_loan_id;
select tty.name
from ra_cust_trx_types tty
,lns_system_options lso
where tty.cust_trx_type_id = decode(p_type, 'PRIN', lso.trx_type_id, 'INT', lso.interest_trx_type_id, 'FEE', lso.fee_trx_type_id);
SELECT nvl(manager.manager_flag,'N') INTO l_loan_manager_flag
FROM
(SELECT
rol.manager_flag,rel.role_resource_id
FROM
jtf_rs_role_relations rel ,
jtf_rs_roles_b rol
WHERE rel.role_id = rol.role_id
and rel.delete_flag <> 'Y'
and sysdate between nvl(rel.start_date_active,sysdate) and nvl(rel.end_date_active,sysdate)
and rol.role_type_code = 'LOANS'
and rol.role_code = 'LOAN_MGR'
and rol.active_flag = 'Y') manager,
jtf_rs_resource_extns res
WHERE
manager.role_resource_id(+) = res.resource_id
and category = 'EMPLOYEE'
and res.start_date_active <= sysdate
and (res.end_date_active is null or res.end_date_active >= sysdate)
and res.user_id = fnd_global.user_id;
SELECT org_id INTO l_org_id
FROM lns_system_options so ;
SELECT enable_budgetary_control_flag INTO l_fv_enabled_flag
FROM gl_ledgers gl, lns_system_options_all so
WHERE so.org_id = p_org_id
AND gl.ledger_id = so.set_of_books_id
AND fnd_profile.value('FV_ENABLED') = 'Y';
SELECT MVIEW_NAME,COMPILE_STATE
FROM USER_MVIEWS
WHERE MVIEW_NAME = p_mv_name;
select request_id
FROM fnd_concurrent_requests fcr,
fnd_concurrent_programs fcp,
fnd_application fa
WHERE fa.application_short_name = p_application_short_name
AND fcp.application_id = fa.application_id
AND fcp.concurrent_program_name = p_concurrent_program_name
AND fcr.program_application_id = fcp.application_id
AND fcr.concurrent_program_id = fcp.concurrent_program_id
--AND fcr.status_code in ('I', 'Q', 'R') --fnd_lookups CP_STATUS_CODE
AND fcr.phase_code <> 'C' --fnd_lookups CP_PHASE_CODE
AND ROWNUM = 1;
SELECT 'Y' INTO l_customer_contact_flag
FROM hz_parties party, fnd_user fnduser
WHERE party.party_type = 'PARTY_RELATIONSHIP'
AND party.status ='A'
AND fnduser.customer_id = party.party_id
AND fnduser.user_id = p_fnd_user_id;
SELECT person_party_id INTO l_subject_id
FROM hz_parties party, fnd_user fnduser
WHERE party.party_type = 'PARTY_RELATIONSHIP'
AND party.status ='A'
AND fnduser.customer_id = party.party_id
AND fnduser.user_id = l_fnd_user_id;
SELECT count(participant.loan_id) INTO l_number_of_loans
FROM lns_participants participant, LNS_LOAN_HEADERS_ALL header
WHERE participant.loan_participant_type in ('PRIMARY_BORROWER','COBORROWER','GUARANTOR')
AND participant.loan_id = header.loan_id
AND header.org_id = l_org_id
AND -- participant.hz_party_id in
participant.loan_id in (SELECT loan_id FROM lns_participants p
where p.hz_party_id
in
(SELECT party_id FROM hz_parties
WHERE party_id in
(SELECT object_id FROM hz_relationships
WHERE subject_id = l_subject_id
AND start_date <= sysdate
AND ((end_date IS null) or (end_date>=sysdate)))
)
)
AND nvl(participant.access_level,decode(participant.loan_participant_type,'PRIMARY_BORROWER',fnd_profile.value('LNS_BORR_ACCESS_LEVEL'),
'COBORROWER',fnd_profile.value('LNS_COBORR_ACCESS_LEVEL'),
'GUARANTOR',fnd_profile.value('LNS_GUAR_ACCESS_LEVEL'))) <> 'NO_ACCESS'
AND header.loan_status in ('INCOMPLETE','ACTIVE', 'APPROVED', 'DEFAULT', 'DELINQUENT', 'IN_FUNDING', 'PAIDOFF', 'PENDING_CANCELLATION')
AND participant.hz_party_id = p_borrower_id;
SELECT org_id INTO l_org_id
FROM lns_system_options so ;
SELECT nvl(purch_encumbrance_flag,'N')
INTO l_encum_enabled_flag
FROM FINANCIALS_SYSTEM_PARAMS_ALL
WHERE org_id = p_org_id; -- Bug 5487757
SELECT enable_budgetary_control_flag INTO l_encum_enabled_flag
FROM gl_ledgers gl, lns_system_options_all so
WHERE so.org_id = p_org_id
AND gl.ledger_id = so.set_of_books_id
AND fnd_profile.value('LNS_ENCUMBRANCE_ENABLE') = 'Y';