128: cond.CONDITION_NAME,
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:
445: cond.CONDITION_NAME,
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:
610: cond.CONDITION_NAME,
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:
774: cond.CONDITION_NAME,
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:
935: cond.CONDITION_NAME,
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: