APPS.LNS_SAMPLE_CUSTOM_CONDS SQL Statements

The following lines contain the word 'select', 'insert', 'update' or 'delete':

Line: 124

        select cond_ass.LOAN_ID,
            cond_ass.OWNER_OBJECT_ID,
            cond_ass.OWNER_TABLE,
            cond.CONDITION_ID,
            cond.CONDITION_NAME,
            cond.CONDITION_DESCRIPTION,
            cond.CONDITION_TYPE,
            cond.MANDATORY_FLAG
        from LNS_CONDITIONS_VL cond,
            LNS_COND_ASSIGNMENTS cond_ass
        where cond_ass.COND_ASSIGNMENT_ID = P_COND_ASSIGNMENT_ID
        and cond.condition_id = cond_ass.condition_id;

Line: 139

        select REQUESTED_AMOUNT
        from lns_loan_headers_all
        where loan_id = P_LOAN_ID;

Line: 198

    l_query_str := ' Select ' || l_column || ' From ' || l_OWNER_TABLE || ' where ' || l_where_clause || ' = ' || l_OWNER_OBJECT_ID;

Line: 441

        select cond_ass.LOAN_ID,
            cond_ass.DISB_HEADER_ID,
            'LNS_DISB_HEADERS',
            cond.CONDITION_ID,
            cond.CONDITION_NAME,
            cond.CONDITION_DESCRIPTION,
            cond.CONDITION_TYPE,
            cond.MANDATORY_FLAG
        from LNS_CONDITIONS_VL cond,
            LNS_COND_ASSIGNMENTS cond_ass
        where cond_ass.COND_ASSIGNMENT_ID = P_COND_ASSIGNMENT_ID
        and cond.condition_id = cond_ass.condition_id;

Line: 456

        select REQUESTED_AMOUNT + nvl(ADD_REQUESTED_AMOUNT, 0)
        from lns_loan_headers_all
        where loan_id = P_LOAN_ID;

Line: 512

    l_query_str := ' Select ' || l_column || ' From ' || l_OWNER_TABLE || ' where ' || l_where_clause || ' = ' || l_OWNER_OBJECT_ID;

Line: 606

        select cond_ass.LOAN_ID,
            cond_ass.DISB_HEADER_ID,
            'LNS_DISB_HEADERS',
            cond.CONDITION_ID,
            cond.CONDITION_NAME,
            cond.CONDITION_DESCRIPTION,
            cond.CONDITION_TYPE,
            cond.MANDATORY_FLAG
        from LNS_CONDITIONS_VL cond,
            LNS_COND_ASSIGNMENTS cond_ass
        where cond_ass.COND_ASSIGNMENT_ID = P_COND_ASSIGNMENT_ID
        and cond.condition_id = cond_ass.condition_id;

Line: 621

        select REQUESTED_AMOUNT + nvl(ADD_REQUESTED_AMOUNT, 0)
        from lns_loan_headers_all
        where loan_id = P_LOAN_ID;

Line: 677

    l_query_str := ' Select ' || l_column || ' From ' || l_OWNER_TABLE || ' where ' || l_where_clause || ' = ' || l_OWNER_OBJECT_ID;

Line: 770

        select cond_ass.LOAN_ID,
            cond_ass.DISB_HEADER_ID,
            'LNS_DISB_HEADERS',
            cond.CONDITION_ID,
            cond.CONDITION_NAME,
            cond.CONDITION_DESCRIPTION,
            cond.CONDITION_TYPE,
            cond.MANDATORY_FLAG
        from LNS_CONDITIONS_VL cond,
            LNS_COND_ASSIGNMENTS cond_ass
        where cond_ass.COND_ASSIGNMENT_ID = P_COND_ASSIGNMENT_ID
        and cond.condition_id = cond_ass.condition_id;

Line: 785

        select PAYMENT_REQUEST_DATE
        from lns_disb_headers
        where disb_header_id = P_DISB_HEADER_ID;

Line: 842

    l_query_str := ' Select ' || l_column || ' From ' || l_OWNER_TABLE || ' where ' || l_where_clause;

Line: 931

        select cond_ass.LOAN_ID,
            cond_ass.DISB_HEADER_ID,
            'LNS_DISB_HEADERS',
            cond.CONDITION_ID,
            cond.CONDITION_NAME,
            cond.CONDITION_DESCRIPTION,
            cond.CONDITION_TYPE,
            cond.MANDATORY_FLAG
        from LNS_CONDITIONS_VL cond,
            LNS_COND_ASSIGNMENTS cond_ass
        where cond_ass.COND_ASSIGNMENT_ID = P_COND_ASSIGNMENT_ID
        and cond.condition_id = cond_ass.condition_id;

Line: 946

        select PAYMENT_REQUEST_DATE
        from lns_disb_headers
        where disb_header_id = P_DISB_HEADER_ID;

Line: 1003

    l_query_str := ' Select ' || l_column || ' From ' || l_OWNER_TABLE || ' where ' || l_where_clause;