APPS.LNS_FUNDING_PUB dependencies on LNS_COND_ASSIGNMENTS

Line 107: WHEN ((select count(1) from LNS_COND_ASSIGNMENTS where DISB_HEADER_ID = head.DISB_HEADER_ID and

103: (nvl(loan.CURRENT_PHASE, 'TERM') = 'TERM' and loan.MULTIPLE_FUNDING_FLAG = 'N' and loan.LOAN_STATUS = 'APPROVED'))
104: THEN
105: CASE
106: /*
107: WHEN ((select count(1) from LNS_COND_ASSIGNMENTS where DISB_HEADER_ID = head.DISB_HEADER_ID and
108: MANDATORY_FLAG = 'Y' and (CONDITION_MET_FLAG is null or CONDITION_MET_FLAG = 'N') and
109: (end_date_active is null or trunc(end_date_active) > trunc(sysdate))) > 0) THEN
110: 'N'
111: ELSE

Line 5142: from LNS_COND_ASSIGNMENTS

5138:
5139: -- checking for conditions
5140: CURSOR conditions_cur(P_DISB_HEADER_ID number) IS
5141: select count(1)
5142: from LNS_COND_ASSIGNMENTS
5143: where
5144: DISB_HEADER_ID = P_DISB_HEADER_ID and
5145: MANDATORY_FLAG = 'Y' and
5146: (CONDITION_MET_FLAG is null or CONDITION_MET_FLAG = 'N') and

Line 8292: LNS_COND_ASSIGNMENTS cond_ass

8288: -- checking for conditions
8289: CURSOR conditions_cur(P_DISB_HEADER_ID number) IS
8290: select count(1)
8291: from LNS_CONDITIONS_VL cond,
8292: LNS_COND_ASSIGNMENTS cond_ass
8293: where cond_ass.DISB_HEADER_ID = P_DISB_HEADER_ID and
8294: cond_ass.MANDATORY_FLAG = 'Y' and
8295: cond_ass.condition_id = cond.condition_id and
8296: cond.CUSTOM_PROCEDURE is null and