APPS.LNS_FEE_ASSIGNMENT_PUB dependencies on LNS_LOAN_PRODUCT_LINES

Line 778: OR EXISTS ( SELECT NULL FROM LNS_LOAN_PRODUCT_LINES

774: CURSOR C_Is_Exist_Assignment (X_Fee_Id NUMBER) IS
775: SELECT 'X' FROM DUAL
776: WHERE EXISTS ( SELECT NULL FROM LNS_FEE_ASSIGNMENTS
777: WHERE FEE_ID = X_FEE_ID )
778: OR EXISTS ( SELECT NULL FROM LNS_LOAN_PRODUCT_LINES
779: WHERE LINE_REFERENCE_ID = X_FEE_ID
780: AND ( LOAN_PRODUCT_LINE_TYPE = 'FEE' OR LOAN_PRODUCT_LINE_TYPE='DISB_FEE' )
781: );
782:

Line 848: LNS_LOAN_PRODUCT_LINES LnsLoanProductLines

844: NULL PHASE,
845: LnsFees.CUSTOM_PROCEDURE
846: FROM LNS_FEES LnsFees ,
847: LNS_LOAN_HEADERS LnsLoanHeaders ,
848: LNS_LOAN_PRODUCT_LINES LnsLoanProductLines
849:
850: WHERE LnsLoanHeaders.LOAN_ID = c_loan_id
851: AND LnsLoanHeaders.PRODUCT_ID = LnsLoanProductLines.LOAN_PRODUCT_ID
852: AND LnsLoanProductLines.LOAN_PRODUCT_LINE_TYPE = 'FEE'

Line 1118: LNS_LOAN_PRODUCT_LINES LnsLoanProductLines

1114: NULL OPEN_PHASE_FLAG,
1115: (select phase from lns_disb_headers where disb_header_id = c_disb_header_id) PHASE,
1116: LnsFees.CUSTOM_PROCEDURE
1117: FROM LNS_FEES LnsFees ,
1118: LNS_LOAN_PRODUCT_LINES LnsLoanProductLines
1119:
1120: WHERE LnsLoanProductLines.PARENT_PRODUCT_LINES_ID = c_loan_prod_line_id
1121: AND LnsLoanProductLines.LOAN_PRODUCT_LINE_TYPE = 'DISB_FEE'
1122: AND LnsLoanProductLines.LINE_REFERENCE_ID = LnsFees.FEE_ID ;