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_OCM_ADP_PUB dependencies on DUAL

Line 382: FROM DUAL

378:
379: x_resultout := FND_API.G_RET_STS_SUCCESS;
380: BEGIN
381: SELECT NVL ( (SELECT 'Y'
382: FROM DUAL
383: WHERE EXISTS ( SELECT null
384: FROM LNS_PARTICIPANTS lp
385: WHERE lp.loan_id = l_cr_loan_id
386: AND lp.loan_participant_type = 'COBORROWER'))

Line 388: FROM DUAL ;

384: FROM LNS_PARTICIPANTS lp
385: WHERE lp.loan_id = l_cr_loan_id
386: AND lp.loan_participant_type = 'COBORROWER'))
387: ,'N' ) INTO l_is_having_coborrowers
388: FROM DUAL ;
389:
390:
391: EXCEPTION
392: WHEN NO_DATA_FOUND THEN

Line 515: FROM DUAL

511:
512: x_resultout := FND_API.G_RET_STS_SUCCESS;
513: BEGIN
514: SELECT NVL ( (SELECT 'Y'
515: FROM DUAL
516: WHERE EXISTS ( SELECT null
517: FROM LNS_PARTICIPANTS lp
518: WHERE lp.loan_id = l_cr_loan_id
519: AND lp.loan_participant_type = 'GUARANTOR'))

Line 521: FROM DUAL ;

517: FROM LNS_PARTICIPANTS lp
518: WHERE lp.loan_id = l_cr_loan_id
519: AND lp.loan_participant_type = 'GUARANTOR'))
520: ,'N' ) INTO l_is_having_guarantors
521: FROM DUAL ;
522:
523:
524: EXCEPTION
525: WHEN NO_DATA_FOUND THEN