APPS.LNS_COND_ASSIGNMENT_PUB dependencies on LNS_COND_ASSIGNMENTS_S

Line 791: select LNS_COND_ASSIGNMENTS_S.NEXTVAL COND_ASSIGNMENT_ID,

787: PROCEDURE create_LP_COND_ASSIGNMENT(
788: P_LOAN_ID IN NUMBER ) IS
789:
790: CURSOR loan_prod_cond ( c_loan_id NUMBER ) IS
791: select LNS_COND_ASSIGNMENTS_S.NEXTVAL COND_ASSIGNMENT_ID,
792: LnsLoanHeaders.LOAN_ID,
793: LnsConditions.CONDITION_ID,
794: LnsConditions.CONDITION_DESCRIPTION,
795: LnsLoanProductLines.MANDATORY_FLAG

Line 1010: select LNS_COND_ASSIGNMENTS_S.NEXTVAL into l_temp_cond_assignment_id from DUAL;

1006:
1007: FETCH loan_prod_disb_cond INTO l_condition_id,l_cond_desc,l_mandatory_flag ;
1008: EXIT WHEN loan_prod_disb_cond%NOTFOUND ;
1009:
1010: select LNS_COND_ASSIGNMENTS_S.NEXTVAL into l_temp_cond_assignment_id from DUAL;
1011: l_cond_assignment_rec.COND_ASSIGNMENT_ID := l_temp_cond_assignment_id;
1012:
1013: --commented below line as it was throwing error PLS-00357 during the build by release team
1014: --l_cond_assignment_rec.COND_ASSIGNMENT_ID := LNS_COND_ASSIGNMENTS_S.NEXTVAL;

Line 1014: --l_cond_assignment_rec.COND_ASSIGNMENT_ID := LNS_COND_ASSIGNMENTS_S.NEXTVAL;

1010: select LNS_COND_ASSIGNMENTS_S.NEXTVAL into l_temp_cond_assignment_id from DUAL;
1011: l_cond_assignment_rec.COND_ASSIGNMENT_ID := l_temp_cond_assignment_id;
1012:
1013: --commented below line as it was throwing error PLS-00357 during the build by release team
1014: --l_cond_assignment_rec.COND_ASSIGNMENT_ID := LNS_COND_ASSIGNMENTS_S.NEXTVAL;
1015:
1016: l_cond_assignment_rec.LOAN_ID := P_LOAN_ID ;
1017: l_cond_assignment_rec.CONDITION_ID := l_condition_id ;
1018: l_cond_assignment_rec.CONDITION_DESCRIPTION := l_cond_desc ;