APPS.LNS_SAMPLE_CUSTOM_CONDS dependencies on LNS_COND_ASSIGNMENTS

Line 133: LNS_COND_ASSIGNMENTS cond_ass

129: cond.CONDITION_DESCRIPTION,
130: cond.CONDITION_TYPE,
131: cond.MANDATORY_FLAG
132: from LNS_CONDITIONS_VL cond,
133: LNS_COND_ASSIGNMENTS cond_ass
134: where cond_ass.COND_ASSIGNMENT_ID = P_COND_ASSIGNMENT_ID
135: and cond.condition_id = cond_ass.condition_id;
136:
137: /* querying loan requested amount */

Line 450: LNS_COND_ASSIGNMENTS cond_ass

446: cond.CONDITION_DESCRIPTION,
447: cond.CONDITION_TYPE,
448: cond.MANDATORY_FLAG
449: from LNS_CONDITIONS_VL cond,
450: LNS_COND_ASSIGNMENTS cond_ass
451: where cond_ass.COND_ASSIGNMENT_ID = P_COND_ASSIGNMENT_ID
452: and cond.condition_id = cond_ass.condition_id;
453:
454: /* querying loan requested amount */

Line 615: LNS_COND_ASSIGNMENTS cond_ass

611: cond.CONDITION_DESCRIPTION,
612: cond.CONDITION_TYPE,
613: cond.MANDATORY_FLAG
614: from LNS_CONDITIONS_VL cond,
615: LNS_COND_ASSIGNMENTS cond_ass
616: where cond_ass.COND_ASSIGNMENT_ID = P_COND_ASSIGNMENT_ID
617: and cond.condition_id = cond_ass.condition_id;
618:
619: /* querying loan requested amount */

Line 779: LNS_COND_ASSIGNMENTS cond_ass

775: cond.CONDITION_DESCRIPTION,
776: cond.CONDITION_TYPE,
777: cond.MANDATORY_FLAG
778: from LNS_CONDITIONS_VL cond,
779: LNS_COND_ASSIGNMENTS cond_ass
780: where cond_ass.COND_ASSIGNMENT_ID = P_COND_ASSIGNMENT_ID
781: and cond.condition_id = cond_ass.condition_id;
782:
783: /* querying loan requested amount */

Line 940: LNS_COND_ASSIGNMENTS cond_ass

936: cond.CONDITION_DESCRIPTION,
937: cond.CONDITION_TYPE,
938: cond.MANDATORY_FLAG
939: from LNS_CONDITIONS_VL cond,
940: LNS_COND_ASSIGNMENTS cond_ass
941: where cond_ass.COND_ASSIGNMENT_ID = P_COND_ASSIGNMENT_ID
942: and cond.condition_id = cond_ass.condition_id;
943:
944: /* querying loan requested amount */