APPS.LNS_COND_ASSIGNMENT_PUB dependencies on LNS_LOAN_PRODUCT_LINES

Line 799: LNS_LOAN_PRODUCT_LINES LnsLoanProductLines

795: LnsLoanProductLines.MANDATORY_FLAG
796:
797: FROM LNS_CONDITIONS LnsConditions ,
798: LNS_LOAN_HEADERS LnsLoanHeaders ,
799: LNS_LOAN_PRODUCT_LINES LnsLoanProductLines
800:
801: WHERE LnsLoanHeaders.LOAN_ID = c_loan_id
802: AND LnsLoanHeaders.PRODUCT_ID = LnsLoanProductLines.LOAN_PRODUCT_ID
803: AND LnsLoanProductLines.LOAN_PRODUCT_LINE_TYPE = 'CONDITION'

Line 823: l_mandatory_flag LNS_LOAN_PRODUCT_LINES.MANDATORY_FLAG%TYPE ;

819: l_cond_assignment_id NUMBER ;
820: l_loan_id NUMBER ;
821: l_condition_id NUMBER ;
822: l_cond_desc LNS_CONDITIONS.CONDITION_DESCRIPTION%TYPE ;
823: l_mandatory_flag LNS_LOAN_PRODUCT_LINES.MANDATORY_FLAG%TYPE ;
824: l_cond_assignment_rec cond_assignment_rec_type ;
825: x_return_status VARCHAR2(1) ;
826: l_loan_status LNS_LOAN_HEADERS.LOAN_STATUS%TYPE ;
827: l_loan_current_phase LNS_LOAN_HEADERS.CURRENT_PHASE%TYPE ;

Line 965: LNS_LOAN_PRODUCT_LINES LnsLoanProductLines

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
969: UNION

Line 974: LNS_LOAN_PRODUCT_LINES LnsLoanProductLines

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'
978: AND LnsLoanProductLines.LINE_REFERENCE_ID = LnsCOnditions.CONDITION_ID

Line 976: (SELECT loan_product_id FROM LNS_LOAN_PRODUCT_LINES WHERE loan_product_lines_id = c_loan_prod_line_id)

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'
978: AND LnsLoanProductLines.LINE_REFERENCE_ID = LnsCOnditions.CONDITION_ID
979: and LnsCOnditions.condition_type = 'DISBURSEMENT';
980:

Line 985: l_mandatory_flag LNS_LOAN_PRODUCT_LINES.MANDATORY_FLAG%TYPE ;

981: l_cond_assignment_id NUMBER ;
982: l_temp_cond_assignment_id NUMBER ;
983: l_condition_id NUMBER ;
984: l_cond_desc LNS_CONDITIONS.CONDITION_DESCRIPTION%TYPE ;
985: l_mandatory_flag LNS_LOAN_PRODUCT_LINES.MANDATORY_FLAG%TYPE ;
986: l_cond_assignment_rec cond_assignment_rec_type ;
987: x_return_status VARCHAR2(1) ;
988:
989: BEGIN

Line 1129: OR EXISTS ( SELECT NULL FROM LNS_LOAN_PRODUCT_LINES

1125: CURSOR C_Is_Exist_Assignment (X_COND_Id NUMBER) IS
1126: SELECT 'X' FROM DUAL
1127: WHERE EXISTS ( SELECT NULL FROM LNS_COND_ASSIGNMENTS
1128: WHERE CONDITION_ID = X_COND_ID )
1129: OR EXISTS ( SELECT NULL FROM LNS_LOAN_PRODUCT_LINES
1130: WHERE LINE_REFERENCE_ID = X_COND_ID
1131: AND ( LOAN_PRODUCT_LINE_TYPE = 'CONDITION' OR LOAN_PRODUCT_LINE_TYPE='DISB_CONDITION' )
1132: );
1133: