eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

APPS.LNS_UTILITY_PUB dependencies on FND_PROFILE

Line 974: AND fnd_profile.value('FV_ENABLED') = 'Y';

970: SELECT enable_budgetary_control_flag INTO l_fv_enabled_flag
971: FROM gl_ledgers gl, lns_system_options_all so
972: WHERE so.org_id = p_org_id
973: AND gl.ledger_id = so.set_of_books_id
974: AND fnd_profile.value('FV_ENABLED') = 'Y';
975:
976: EXCEPTION
977: WHEN NO_DATA_FOUND THEN
978: l_fv_enabled_flag := 'N' ;

Line 1180: AND nvl(participant.access_level,decode(participant.loan_participant_type,'PRIMARY_BORROWER',fnd_profile.value('LNS_BORR_ACCESS_LEVEL'),

1176: AND start_date <= sysdate
1177: AND ((end_date IS null) or (end_date>=sysdate)))
1178: )
1179: )
1180: AND nvl(participant.access_level,decode(participant.loan_participant_type,'PRIMARY_BORROWER',fnd_profile.value('LNS_BORR_ACCESS_LEVEL'),
1181: 'COBORROWER',fnd_profile.value('LNS_COBORR_ACCESS_LEVEL'),
1182: 'GUARANTOR',fnd_profile.value('LNS_GUAR_ACCESS_LEVEL'))) <> 'NO_ACCESS'
1183: AND header.loan_status in ('INCOMPLETE','ACTIVE', 'APPROVED', 'DEFAULT', 'DELINQUENT', 'IN_FUNDING', 'PAIDOFF', 'PENDING_CANCELLATION')
1184: AND participant.hz_party_id = p_borrower_id;

Line 1181: 'COBORROWER',fnd_profile.value('LNS_COBORR_ACCESS_LEVEL'),

1177: AND ((end_date IS null) or (end_date>=sysdate)))
1178: )
1179: )
1180: AND nvl(participant.access_level,decode(participant.loan_participant_type,'PRIMARY_BORROWER',fnd_profile.value('LNS_BORR_ACCESS_LEVEL'),
1181: 'COBORROWER',fnd_profile.value('LNS_COBORR_ACCESS_LEVEL'),
1182: 'GUARANTOR',fnd_profile.value('LNS_GUAR_ACCESS_LEVEL'))) <> 'NO_ACCESS'
1183: AND header.loan_status in ('INCOMPLETE','ACTIVE', 'APPROVED', 'DEFAULT', 'DELINQUENT', 'IN_FUNDING', 'PAIDOFF', 'PENDING_CANCELLATION')
1184: AND participant.hz_party_id = p_borrower_id;
1185:

Line 1182: 'GUARANTOR',fnd_profile.value('LNS_GUAR_ACCESS_LEVEL'))) <> 'NO_ACCESS'

1178: )
1179: )
1180: AND nvl(participant.access_level,decode(participant.loan_participant_type,'PRIMARY_BORROWER',fnd_profile.value('LNS_BORR_ACCESS_LEVEL'),
1181: 'COBORROWER',fnd_profile.value('LNS_COBORR_ACCESS_LEVEL'),
1182: 'GUARANTOR',fnd_profile.value('LNS_GUAR_ACCESS_LEVEL'))) <> 'NO_ACCESS'
1183: AND header.loan_status in ('INCOMPLETE','ACTIVE', 'APPROVED', 'DEFAULT', 'DELINQUENT', 'IN_FUNDING', 'PAIDOFF', 'PENDING_CANCELLATION')
1184: AND participant.hz_party_id = p_borrower_id;
1185:
1186: logMessage(FND_LOG.LEVEL_PROCEDURE, G_PKG_NAME,' Loan Count - ' || l_number_of_loans);

Line 1295: AND fnd_profile.value('LNS_ENCUMBRANCE_ENABLE') = 'Y';

1291: SELECT enable_budgetary_control_flag INTO l_encum_enabled_flag
1292: FROM gl_ledgers gl, lns_system_options_all so
1293: WHERE so.org_id = p_org_id
1294: AND gl.ledger_id = so.set_of_books_id
1295: AND fnd_profile.value('LNS_ENCUMBRANCE_ENABLE') = 'Y';
1296:
1297:
1298:
1299: EXCEPTION