APPS.LNS_COND_ASSIGNMENT_PUB dependencies on LNS_CONDITIONS_VL

Line 964: FROM LNS_CONDITIONS_VL LnsConditions ,

960: CURSOR loan_prod_disb_cond ( c_loan_prod_line_id NUMBER ) IS
961: select LnsConditions.CONDITION_ID,
962: LnsConditions.CONDITION_DESCRIPTION,
963: LnsLoanProductLines.MANDATORY_FLAG
964: FROM LNS_CONDITIONS_VL LnsConditions ,
965: LNS_LOAN_PRODUCT_LINES LnsLoanProductLines
966: WHERE LnsLoanProductLines.PARENT_PRODUCT_LINES_ID = c_loan_prod_line_id
967: AND LnsLoanProductLines.LOAN_PRODUCT_LINE_TYPE = 'DISB_CONDITION'
968: AND LnsLoanProductLines.LINE_REFERENCE_ID = LnsCOnditions.CONDITION_ID

Line 973: FROM LNS_CONDITIONS_VL LnsConditions ,

969: UNION
970: select LnsConditions.CONDITION_ID,
971: LnsConditions.CONDITION_DESCRIPTION,
972: LnsLoanProductLines.MANDATORY_FLAG
973: FROM LNS_CONDITIONS_VL LnsConditions ,
974: LNS_LOAN_PRODUCT_LINES LnsLoanProductLines
975: WHERE LnsLoanProductLines.loan_product_id =
976: (SELECT loan_product_id FROM LNS_LOAN_PRODUCT_LINES WHERE loan_product_lines_id = c_loan_prod_line_id)
977: AND LnsLoanProductLines.LOAN_PRODUCT_LINE_TYPE = 'CONDITION'

Line 1200: from LNS_CONDITIONS_VL cond,

1196: cond.CONDITION_DESCRIPTION,
1197: cond.CONDITION_TYPE,
1198: cond_ass.MANDATORY_FLAG,
1199: cond.CUSTOM_PROCEDURE
1200: from LNS_CONDITIONS_VL cond,
1201: LNS_COND_ASSIGNMENTS cond_ass
1202: where decode(P_CONDITION_TYPE, 'APPROVAL', cond_ass.LOAN_ID,
1203: 'CONVERSION', cond_ass.LOAN_ID,
1204: 'DISBURSEMENT', cond_ass.DISB_HEADER_ID,

Line 1414: from LNS_CONDITIONS_VL cond,

1410: cond.CONDITION_DESCRIPTION,
1411: cond.CONDITION_TYPE,
1412: cond_ass.MANDATORY_FLAG,
1413: cond.CUSTOM_PROCEDURE
1414: from LNS_CONDITIONS_VL cond,
1415: LNS_COND_ASSIGNMENTS cond_ass
1416: where cond_ass.cond_assignment_id = P_COND_ASSIGNMENT_ID
1417: and cond.condition_id = cond_ass.condition_id
1418: and cond_ass.END_DATE_ACTIVE is null;

Line 1570: from LNS_CONDITIONS_VL cond,

1566: cond.CONDITION_NAME,
1567: cond.CONDITION_DESCRIPTION,
1568: cond_ass.MANDATORY_FLAG,
1569: cond_ass.DELETE_DISABLED_FLAG
1570: from LNS_CONDITIONS_VL cond,
1571: LNS_COND_ASSIGNMENTS cond_ass
1572: where cond_ass.LOAN_ID = P_LOAN_ID
1573: and cond.CONDITION_TYPE = P_CONDITION_TYPE
1574: and cond.condition_id = cond_ass.condition_id

Line 1766: from LNS_CONDITIONS_VL cond,

1762:
1763: -- checking for number of not met non-custom conditions
1764: CURSOR conditions_cur(P_OWNER_OBJECT_ID number, P_CONDITION_TYPE varchar2) IS
1765: select count(1)
1766: from LNS_CONDITIONS_VL cond,
1767: LNS_COND_ASSIGNMENTS cond_ass
1768: where
1769: decode(P_CONDITION_TYPE, 'APPROVAL', cond_ass.LOAN_ID,
1770: 'CONVERSION', cond_ass.LOAN_ID,