DBA Data[Home] [Help]

APPS.LNS_FEE_ASSIGNMENT_PUB dependencies on LNS_FEE_ASSIGNMENTS_S

Line 806: select LNS_FEE_ASSIGNMENTS_S.NEXTVAL FEE_ASSIGNMENT_ID,

802: PROCEDURE create_LP_FEE_ASSIGNMENT(
803: P_LOAN_ID IN NUMBER ) IS
804:
805: CURSOR loan_prod_fee ( c_loan_id NUMBER ) IS
806: select LNS_FEE_ASSIGNMENTS_S.NEXTVAL FEE_ASSIGNMENT_ID,
807: LnsLoanHeaders.LOAN_ID,
808: LnsFees.FEE_ID,
809: --decode(LnsFees.RATE_TYPE,'VARIABLE', lns_fee_engine.calculateFee(LnsFees.FEE_ID,LnsLoanHeaders.LOAN_ID) , LnsFees.FEE) FEE,
810: LnsFees.FEE,

Line 1082: select LNS_FEE_ASSIGNMENTS_S.NEXTVAL FEE_ASSIGNMENT_ID,

1078: PROCEDURE create_LP_DISB_FEE_ASSIGNMENT(
1079: P_DISB_HEADER_ID IN NUMBER , P_LOAN_PRODUCT_LINE_ID IN NUMBER, P_LOAN_ID IN NUMBER ) IS
1080:
1081: CURSOR loan_prod_disb_fee ( c_disb_header_id NUMBER , c_loan_prod_line_id NUMBER, c_loan_id NUMBER ) IS
1082: select LNS_FEE_ASSIGNMENTS_S.NEXTVAL FEE_ASSIGNMENT_ID,
1083: c_loan_id LOAN_ID,
1084: LnsFees.FEE_ID,
1085: LnsFees.FEE,
1086: LnsFees.FEE_TYPE,