APPS.LNS_FEE_ASSIGNMENT_PUB dependencies on LNS_LOAN_PRODUCT_LINES

Line 760: OR EXISTS ( SELECT NULL FROM LNS_LOAN_PRODUCT_LINES

756: CURSOR C_Is_Exist_Assignment (X_Fee_Id NUMBER) IS
757: SELECT 'X' FROM DUAL
758: WHERE EXISTS ( SELECT NULL FROM LNS_FEE_ASSIGNMENTS
759: WHERE FEE_ID = X_FEE_ID )
760: OR EXISTS ( SELECT NULL FROM LNS_LOAN_PRODUCT_LINES
761: WHERE LINE_REFERENCE_ID = X_FEE_ID
762: AND ( LOAN_PRODUCT_LINE_TYPE = 'FEE' OR LOAN_PRODUCT_LINE_TYPE='DISB_FEE' )
763: );
764:

Line 821: LNS_LOAN_PRODUCT_LINES LnsLoanProductLines

817: LnsLoanProductLines.MANDATORY_FLAG
818:
819: FROM LNS_FEES LnsFees ,
820: LNS_LOAN_HEADERS LnsLoanHeaders ,
821: LNS_LOAN_PRODUCT_LINES LnsLoanProductLines
822:
823: WHERE LnsLoanHeaders.LOAN_ID = c_loan_id
824: AND LnsLoanHeaders.PRODUCT_ID = LnsLoanProductLines.LOAN_PRODUCT_ID
825: AND LnsLoanProductLines.LOAN_PRODUCT_LINE_TYPE = 'FEE'

Line 1075: LNS_LOAN_PRODUCT_LINES LnsLoanProductLines

1071: NULL END_DATE_ACTIVE,
1072: c_disb_header_id DISB_HEADER_ID,
1073: LnsLoanProductLines.MANDATORY_FLAG
1074: FROM LNS_FEES LnsFees ,
1075: LNS_LOAN_PRODUCT_LINES LnsLoanProductLines
1076:
1077: WHERE LnsLoanProductLines.PARENT_PRODUCT_LINES_ID = c_loan_prod_line_id
1078: AND LnsLoanProductLines.LOAN_PRODUCT_LINE_TYPE = 'DISB_FEE'
1079: AND LnsLoanProductLines.LINE_REFERENCE_ID = LnsFees.FEE_ID ;