82: ' WHERE ' || x_value || ' = ' ||
83: V_FK_TABLE_SHORT_NAME || '.' || V_PK_ID;
84:
85: if V_PK_ID2 is not null then
86: v_sql_statement := v_sql_statement || ' and ' || QLTNINRB.NAME_IN(V_FK_ID2) ||
87: ' = ' || V_FK_TABLE_SHORT_NAME || '.' || V_PK_ID2;
88: if V_PK_ID3 is not null then
89: v_sql_statement := v_sql_statement || ' and ' || QLTNINRB.NAME_IN(V_FK_ID3) ||
90: ' = ' || V_FK_TABLE_SHORT_NAME || '.' || V_PK_ID3;
85: if V_PK_ID2 is not null then
86: v_sql_statement := v_sql_statement || ' and ' || QLTNINRB.NAME_IN(V_FK_ID2) ||
87: ' = ' || V_FK_TABLE_SHORT_NAME || '.' || V_PK_ID2;
88: if V_PK_ID3 is not null then
89: v_sql_statement := v_sql_statement || ' and ' || QLTNINRB.NAME_IN(V_FK_ID3) ||
90: ' = ' || V_FK_TABLE_SHORT_NAME || '.' || V_PK_ID3;
91: end if;
92: end if;
93: if V_FK_ADD_WHERE is not null then