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 380: FROM DUAL

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

Line 386: FROM DUAL ;

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

Line 513: FROM DUAL

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

Line 519: FROM DUAL ;

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