APPS.LNS_LOAN_PUB dependencies on LNS_FEE_ASSIGNMENTS

Line 2500: select LNS_FEE_ASSIGNMENTS_S.NEXTVAL FEE_ASSIGNMENT_ID,

2496: ,x_msg_data OUT nocopy VARCHAR2)
2497: IS
2498:
2499: CURSOR loan_prod_fee ( c_loan_id NUMBER ) IS
2500: select LNS_FEE_ASSIGNMENTS_S.NEXTVAL FEE_ASSIGNMENT_ID,
2501: LnsLoanHeaders.LOAN_ID,
2502: LnsFees.FEE_ID,
2503: --decode(LnsFees.RATE_TYPE,'VARIABLE', lns_fee_engine.calculateFee(LnsFees.FEE_ID,LnsLoanHeaders.LOAN_ID) ,LnsFees.FEE) FEE,
2504: LnsFees.FEE,

Line 2562: (SELECT NULL FROM LNS_FEE_ASSIGNMENTS LnsFeeAssignments

2558: SELECT 'Y'
2559: FROM DUAL
2560: WHERE
2561: EXISTS
2562: (SELECT NULL FROM LNS_FEE_ASSIGNMENTS LnsFeeAssignments
2563: WHERE LnsFeeAssignments.LOAN_ID = c_loan_id)
2564: OR EXISTS
2565: (SELECT NULL FROM LNS_LOAN_HISTORIES_H
2566: WHERE TABLE_NAME = 'LNS_FEE_ASSIGNMENTS' AND LOAN_ID = c_loan_id) ;

Line 2566: WHERE TABLE_NAME = 'LNS_FEE_ASSIGNMENTS' AND LOAN_ID = c_loan_id) ;

2562: (SELECT NULL FROM LNS_FEE_ASSIGNMENTS LnsFeeAssignments
2563: WHERE LnsFeeAssignments.LOAN_ID = c_loan_id)
2564: OR EXISTS
2565: (SELECT NULL FROM LNS_LOAN_HISTORIES_H
2566: WHERE TABLE_NAME = 'LNS_FEE_ASSIGNMENTS' AND LOAN_ID = c_loan_id) ;
2567:
2568: l_fee_assignment_rec LNS_FEE_ASSIGNMENT_PUB.fee_assignment_rec_type ;
2569: l_fee_assignment_id NUMBER ;
2570: l_loan_status LNS_LOAN_HEADERS.LOAN_STATUS%TYPE ;