DBA Data[Home] [Help]

APPS.LNS_FEE_ASSIGNMENT_PUB dependencies on LNS_FEE_ASSIGNMENTS_S

Line 788: select LNS_FEE_ASSIGNMENTS_S.NEXTVAL FEE_ASSIGNMENT_ID,

784: PROCEDURE create_LP_FEE_ASSIGNMENT(
785: P_LOAN_ID IN NUMBER ) IS
786:
787: CURSOR loan_prod_fee ( c_loan_id NUMBER ) IS
788: select LNS_FEE_ASSIGNMENTS_S.NEXTVAL FEE_ASSIGNMENT_ID,
789: LnsLoanHeaders.LOAN_ID,
790: LnsFees.FEE_ID,
791: decode(LnsFees.RATE_TYPE,'VARIABLE', lns_fee_engine.calculateFee(LnsFees.FEE_ID,LnsLoanHeaders.LOAN_ID) , LnsFees.FEE) FEE,
792: LnsFees.FEE_TYPE,

Line 1044: select LNS_FEE_ASSIGNMENTS_S.NEXTVAL FEE_ASSIGNMENT_ID,

1040: PROCEDURE create_LP_DISB_FEE_ASSIGNMENT(
1041: P_DISB_HEADER_ID IN NUMBER , P_LOAN_PRODUCT_LINE_ID IN NUMBER, P_LOAN_ID IN NUMBER ) IS
1042:
1043: CURSOR loan_prod_disb_fee ( c_disb_header_id NUMBER , c_loan_prod_line_id NUMBER ) IS
1044: select LNS_FEE_ASSIGNMENTS_S.NEXTVAL FEE_ASSIGNMENT_ID,
1045: NULL LOAN_ID,
1046: LnsFees.FEE_ID,
1047: LnsFees.FEE,
1048: LnsFees.FEE_TYPE,